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.5 |
model | standard or advanced (paid plans). See AI models | standard |
bypassCache | Set to true to ignore the cached result and generate again. | false |