FIX WRITING

Correct grammar issues and typos within a spreadsheet range using ChatGPT power

It automatically corrects text within a spreadsheet range, focusing on improving grammar, spelling, and readability. It's perfect for refining reports, emails, or any written content, utilizing ChatGPT's capabilities to ensure your Google Sheets are free of spelling mistakes.

Examples

Arguments List

=FIXWRITING_X(range, [options])
=FIXWRITING_Y(range, [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: {"tone","Casual"; "extra_instructions","Remember this info: " & A1}

mode

The mode affects the result, speed, and cost of Smart Function execution by specializing ChatGPT instructions and setting defaults for other parameters.
Fast (default): Prioritizes speed and corrects spelling.
Make Better: Rewrites text to enhance readability and sophistication.
Make Shorter: Fix errors and make the text shorter.
Make Longer: Fix errors and make the text longer.
Options: "fast", "rewrite", "shorter", or "longer"

temperature

Adjust ChatGPT's deviation from deterministic answers between 0 (high confidence) and 1 (greater diversity). This setting controls the AI's creativity level when fixing errors or enhancing the provided text.
For Example: 0, 0.2, or 1

extra_instructions

Provide additional information or instructions for ChatGPT to get a better result.
For example: "Keep slang words", "Do not use abbreviations", or "Remember this: " & B2

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: Maximizes function calculation efficiency for a Google Sheets range by sending individual ChatGPT requests per cell, though it may lead to contextually disconnected outcomes.
None: Compiles the entire cell range into a single request, which could become too large but is favored for context-aware responses.
Options: "default", "max", or "none"

max_tokens

Control the maximum number of tokens that can be utilized in the function execution. By default, this limit is set based on the type of call, helping to safeguard your account against unnecessary expenses.

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 fixing. 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 N$8

generate_warning

This message 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 message.

For Example: "default", "Choose a type of fixing", or B18

Sidebar Options

Because of limitations with Google Sheets, specific options are not usable in Smart Formulas. However, these options can still be accessed through a Smart Function via the Websheet AI sidebar.