GPT Workspace
  • GPT Workspace
  • Get started: Add-on
  • Get started: Chrome Extension
  • Subscription
    • Manage my subscription
    • Team subscription
    • Downloading invoices
  • Pricing and Models
    • What is a credit?
    • AI Models
    • Pay per usage
  • Products
    • GPT for Google Sheets
      • Formulas
        • GPT formula
        • GPT_WEB formula
        • GPT_LIST formula
        • GPT_TABLE formula
        • GPT_IMAGE formula
        • GPT_TRANSLATE formula
        • GPT_COMPLETE formula
      • Default Model, Temperature and Output size for GPT Formulas
      • Refresh or Freeze GPT cells
    • GPT for Google Docs
    • GPT for Google Slides
    • GPT for Gmail
  • FAQ
    • How to change the language?
    • Internet Access with GPT?
    • How to launch the GPT Gmail and GPT Drive add-on
    • I can't find the add-on from the sidebar
    • I can't install the extension
    • Is GPT Workspace included with ChatGPT Plus or Enterprise?
    • How to uninstall GPT Workspace
    • Do custom assistants have any limitations?
  • Resources
    • Common Errors
    • Tutorials and Resources
    • Data and Privacy
Powered by GitBook
On this page
  1. Products
  2. GPT for Google Sheets
  3. Formulas

GPT_COMPLETE formula

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 or advanced (gpt-4o-mini or gpt-4o)

standard

bypassCache

Bypass the cache and query openai again. The results will be differents than before.

false

PreviousGPT_TRANSLATE formulaNextDefault Model, Temperature and Output size for GPT Formulas

Last updated 6 months ago