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.


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.

=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:
=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:
=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:
Arguments List
=CHOOSE_X(value, variants, [options])
=CHOOSE_Y(value, variants, [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","Marketer"}
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.