Skip to main content

Set the creativity level for GPT functions

Set the creativity level that will be used for GPT functions in your spreadsheet to define how standard (or not) your output is expected to be. You can find out more about the temperature setting, used by OpenAI to set a creativity level, in our Temperature guide.

  1. In the sidebar menu, select GPT functions.

    Sidebar menu

  2. Select Model settings.

    Model settings

  3. Use the slider to set Creativity between 0 and 1.

    Creativity level in GPT for Excel

GPT for Sheets uses the creativity level to generate all responses for GPT functions in the current spreadsheet.

info

When cache is enabled, existing GPT formulas will not automatically update to the new creativity level when you re-execute them.

To re-execute an existing formula with the new creativity level:

  1. Set the temperature parameter directly in the formula.

  2. Press Enter to re-execute the formula.

What's next