GPT_COMPLETE formula
Complete cells with =GPT_COMPLETE
Section titled “Complete cells with =GPT_COMPLETE”Use GPT to complete result from given values
=GPT_COMPLETE(rangeKeys, rangeValues, rangeKeysToComplete, temperature, model, cache)
| Parameter | Description | Default |
|---|---|---|
rangeKeys | rangeKeys range of cells (keys) required | |
rangeValues | rangeValues range of cells (values) required | |
rangeKeysToComplete | rangeKeysToComplete range of cells (keys) to complete it's range of cells (values) required | |
temperature | Between 0 (not creative) and 2 (very creative) | 0 |
model | standard (GLM 5.2, 1 credit/token) or advanced (GLM 5.2 nitro, 5 credits/token, paid plans) | standard |
bypassCache | Bypass the cache and query openai again. The results will be differents than before. | false |