Перейти до вмісту

AI Sheet Formulas

Цей контент ще не доступний вашою мовою.

AI Sheet Formulas brings AI directly into your grid so you can run structured prompts from regular sheet formulas.

Available Formulas

=AITASK(instruction, input_range, [refresh])
=AIPATTERN(example_range, target_range, [refresh])
=AIDRAFT(prompt, context_range, [refresh])
=AISPLIT(text, split_instruction, [refresh])
=AITABLE(prompt, [context_range], [refresh])

Before You Start

Open the add-on sidebar once and ensure you are signed in.
Use a checkbox cell (for example $Z$1) as the optional [refresh] argument to force recalculation when needed.
Use range-based formulas for batch tasks (for example A2:A200) instead of dragging one-cell formulas down.

Common Examples

=AITASK("Extract the primary domain from this email address", A2:A50, $Z$1)

=AIPATTERN(A2:B5, A6:A100, $Z$1)

=AIDRAFT("Write a short follow-up email based on this note:", C2:C20, $Z$1)

=AISPLIT(A2, "Split into First Name, Last Name, City", $Z$1)

=AITABLE("List the top 10 US cities by population with state and population", , $Z$1)

Limits and Notes

Formula names use AI... without dots (AITASK, not AI.TASK).
AISPLIT processes one cell per invocation.
AITABLE and AISPLIT spill into nearby cells; clear output space first to avoid #REF!.
Formula outputs are plain text. Use AI Agents for post-processing and formatting.

Troubleshooting

Error: Not authorized...: open the sidebar and sign in again.
Error: Range too large...: split the range into smaller batches.
#REF!: clear cells in the spill path.
#ERROR!: reduce range size and retry.

AI Agents Use sidebar-driven AI workflows for value updates, formatting, formulas, and filters.

Language & Settings Control AI permission behavior for add-on features.