Icon of Choose AI Function: One blue box at the top is connected with two blue boxes at the bottom with lines demonstrating choosing. The left bottom box is darker because it's chosen. At the middle of the composition, a question mark is inside the dark blue circle.

CHOOSE

Categorize a spreadsheet value based on a list of predefined options using ChatGPT

It is a ChatGPT-based tool for categorizing and analyzing data in your Google Sheets across multiple domains, such as user feedback, real estate listings, and content moderation. This enables efficient, context-specific decision-making. Converting qualitative data into quantitative data transforms your Google spreadsheets into powerful data analysis tools.

Examples
=CHOOSE_X(D2, "Very Positive Review, Overall Positive Review, Product Issue, Mismatch of Description and Product, Delivery Issue, Too Pricey")

Output Example: Delivery Issue
=CHOOSE_X(G2, "Apartment, House, Townhouse, Villa, Studio, Duplex, Penthouse, Commercial, Industrial, Land, Condo, Loft", {"extra_instructions", "Consider size, location, and amenities in the description"; "act_like", "Real Estate Agent"})

Output Example:
Townhouse
=CHOOSE_X(Essays!D2,  "A+, A, A-, B+, B, B-, C+, C, C-, D+, D, F", {"extra_instructions", "Assess based on depth of analysis, clarity of expression, structure, grammar, and originality"; "act_like", "English Teacher"})

Output Example:
A-
=CHOOSE_X(Posts!A2:G2, "Appropriate, Questionable, Inappropriate, Needs Review, Escalate", {"extra_instructions", "Forum Rules: " & TEXTJOIN("; ", TRUE, Rules!A2:A10); "act_like", "Senior Community Moderator"; "temperature", 0.7})

Output Example:
Inappropriate
Arguments List
=CHOOSE_X(value, variants, [options])
=CHOOSE_Y(value, variants, [options])
value
A spreadsheet cell or range to be categorized using provided variants.
For example: A2 or A2:A6
variants
A list of variants separated by commas. The most suitable variant will be chosen based on the value provided.
For example: "Positive, Neutral, Negative" or B2
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","Marketer"}
temperature
Adjusts from precise (0) to exploratory (1) choices, influencing the selection's creativity and variety.
For Example: 0, 0.4, or 1
act_like
Specify a role, profession, or perspective for the AI to utilize when making selections; this parameter directs the AI towards more context-sensitive or specialized choices.
For example: "Marketer", "Data Analyst", or "Product Analyst"
extra_instructions
Offer more details or guidelines to enhance the outcome.
For example: "Our system uses 12 stars", "If the text ends with an ellipsis (three dots), it should be considered Unfinished", or "Remember this: " & B2
with_kb
When activated, Smart Function uses Knowledge Base sources to make the right choice based on Knowledge Base data.
Options: TRUE or FALSE
with_kb2
When activated, Smart Function uses Knowledge Base sources for the answer, but in a later stage, which is good in combination with extra_instructions and activated with_thinking.
Options: TRUE or FALSE
with_web
When activated, Smart Function uses web search to improve choices with the latest information from Google Search, leading to longer waiting times and higher costs.
Options: TRUE or FALSE
with_thinking
When activated, it adds an extra thinking step to help make a better choice. This makes the function take longer and cost more.
Options: TRUE or FALSE
model
Model affects quality, speed, and tokens count of tokens to use. We choose the optimal model ("default") by default. Information about models.
Options: "default", "gpt-4, "gpt-3.5-turbo", or "gpt-3.5-turbo-16k"
tags
Tags filter Knowledge Base sources for more specified choices. Start by adding tags to the Knowledge Base sheet. Next, turn on with_kb or with_kb2 to make these tags work.
For example: "categories", "products", or C2
max_tokens
Set a cap on the token count available for a single ChatGPT operation. The default limitation safeguards your balance against excessive use.
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
When set to TRUE, the formula proceeds with the calculation. When set to FALSE, a warning message is displayed. To avoid accidental costs, connect this parameter to a Google Sheet cell containing a checkbox or a formula for input validation.
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 Option
Due to Google Sheets' limitations, a specific feature may not be available for Smart Formulas. However, this feature can be accessed through a Smart Function in the Websheet AI sidebar.
Result Location
The spreadsheet cell where the summary will be inserted. It's useful when you want not only to read the summary but also paste it to the specific cell.
For Example: =B2