EDIT

Edits values in a spreadsheet range according to user instructions using ChatGPT's AI

The Edit Smart Function is a versatile tool that modifies spreadsheet cell values within a specified range based on your guidelines. Whether you need data cleaning, text formatting, or quick value updates, EDIT_X will handle it using ChatGPT's capabilities. Transforming Google Sheets with the Edit Smart Function is a pleasure; there's no need to understand complicated formulas. Just write what you want in simple language, and it will transform the value in a cell as you wish.

Examples

Arguments List

=EDIT_X(range, instructions, [options])
=EDIT_Y(range, instructions, [options])

Options List

Particular object at the end of a formula which contains optional parameters values in the form {"parameter_name",value; "next_parameter_name",value}
For Example: {"extra_instructions","Remember this info: " & A1; "act_like","English Teacher"}

temperature

Adjust ChatGPT's deviation from deterministic to creative answers, ranging from 0 (high confidence) to 1 (greater diversity). In other words, it's the AI's creativity for the answer.
For Example: 0, 0.1, or 1

act_like

Specify a role, profession, or perspective for the AI to adopt when editing the values of spreadsheet cells; this parameter guides the ChatGPT in providing more context-specific or specialized editing.
For example: "UX Designer", "Data Analyst", or "Professional Writer"

extra_instructions

Provide additional information or instructions to achieve better results. This is useful for separating main instructions from supplementary ones, helping to maintain a clean structure in your Google Sheets.
For example: "Remember about using the metric system", "Also, fix grammar", or "Remember this: " & $G$2

model

Model affects quality, speed, and tokens count of tokens to use. We choose the optimal model ("default") by default, and here it's gpt-4. Information about models.
Options: "default", "gpt-4, "gpt-3.5-turbo", or "gpt-3.5-turbo-16k"

in_parallel

For each cell: Applying parallel execution to each cell in the Google Sheets range, up to the max, significantly speeds up function calculation. This method involves making an individual ChatGPT request for each cell, which can result in repetitive data.
None: Non-parallel execution can lead to request size issues, as the entire spreadsheet range is sent in one request, potentially making it too large. This approach, however, is necessary for context-based answers and ensuring non-repetitive editing.
Options: "default", "max", or "none"

max_tokens

Limit the number of tokens that can be used for one ChatGPT function run. By default, it's limited depending on the type of call and protects your balance from unwanted spending.
1 token ≈ 4 chars in English
1 token ≈ 3/4 words
100 tokens ≈ 75 words
1-2 sentences ≈ 30 tokens
1 paragraph ≈ 100 tokens
1,500 words ≈ 2048 tokens
For Example: 100, 350, or 2048

generate

If set to TRUE, the formula will carry out the calculation. If set to FALSE, a warning text will appear instead. To prevent unintended expenses, link this parameter to a Google Sheet cell with a checkbox or a formula that verifies inputs.

For Example: TRUE, FALSE, or G18

generate_warning

This text will appear when 'generate' is set to FALSE. As a best practice, include instructions on what actions are required to activate the calculation. Use the codeword [STOP] to halt the calculation of related formulas; this will not be visible to the user. Use the word "default" to display a standard warning message.

For Example: "default", "Fill out all inputs", or J18

Sidebar Options

Due to Google Sheets limitations, those options cannot be used in Smart Formulas but are available for a Smart Function call from the Websheet AI sidebar.