Icon of Edit AI Function: Yellow pen on the background of whitish paper

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.

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"}
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.