AI Sheet Formulas

AI Sheet Formulas add-on ke AI workflow ko seedha spreadsheet grid me le aata hai. Har task ke liye sidebar kholne ke bajay aap =AIASK(...) jaisi custom formula type kar sakte hain aur AI-generated results ko sheet me spill kar sakte hain.

Shuru Karne Se Pehle

Add-on sidebar ko ek baar kholiye aur usi account/profile me sign in complete kijiye.
Ensure kijiye ki subscription aur AI access active ho.
Agar aap recalculation force karna chahte hain to $Z$1 jaisi checkbox cell ko optional [refresh] argument ke roop me use kijiye.
Single-cell formula ko neeche drag karne ke bajay A2:A50 jaisi range-based formulas use kijiye.

Available Formulas

=AIASK(instruction, [input_range], [refresh])
=AITAG(value, tags, [refresh])
=AITRANSLATE(input_range, target_language, [refresh])
=AIVOCAB(text_range, language, [refresh])
=AIPATTERN(example_range, target_range, [refresh])
=AIDRAFT(prompt, context_range, [refresh])
=AIMERGE(instruction, input_range, [refresh])
=AISPLIT(input_range, split_instruction, [refresh])
=AITABLE(prompt, [context_range], [refresh])
=AIREVERSECALC(target_ref, input_range_ref, [max_candidates], [tolerance], [refresh])

Har Formula Kya Karti Hai

AIASK: ek range ke liye batch extraction, cleanup, ya question answering
AITAG: allowed tag list ka upyog karke har value ko tag karta hai
AITRANSLATE: har value ko target language me translate karta hai
AIVOCAB: ek key vocabulary item nikalta hai aur Term | Pronunciation | Meaning | Example sentence return karta hai
AIPATTERN: example input-output pairs se transformation pattern sikhkar target range par apply karta hai
AIDRAFT: har row ke liye ek drafted output generate karta hai
AIMERGE: har row ko ek AI-composed summary ya output cell me merge karta hai
AISPLIT: har input row ko structured parts me split karta hai jo columns me spill hote hain
AITABLE: headers ke sath ek poori text table generate karta hai jo rows aur columns me spill hoti hai
AIREVERSECALC: source range se target value ko recreate karne ke liye candidate formulas suggest karta hai

Common Examples

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

=AITAG(A2:A200, "van life, freedom, outdoors", $Z$1)

=AITRANSLATE(A2:A200, "German", $Z$1)

=AIVOCAB(A2:A50, "English", $Z$1)

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

=AIDRAFT("Write a 2-sentence polite rejection email citing this reason:", C2:C20, $Z$1)

=AIMERGE("Summarize each row in one sentence", A2:C50, $Z$1)

=AISPLIT(A2:A50, "Split into Name, City, Issue", $Z$1)

=AITABLE("List the top 5 US cities by population with columns for State, Mayor, and Population", , $Z$1)

=AIREVERSECALC("E10", "A2:C10", 5, 0.01, $Z$1)

Batch Limits Aur Output Notes

Formula	Typical limit	Output behavior
`AIASK`, `AITAG`, `AITRANSLATE`, `AIMERGE`	200 rows	Har input row ke liye ek output return karta hai
`AIPATTERN`	200 target rows, max 10 example pairs	Har target row ke liye transformed output return karta hai
`AISPLIT`	200 rows	Structured multi-column output return karta hai
`AIVOCAB`	200 input cells	Ek 4-column row return karta hai
`AIDRAFT`	50 rows	Har row ke liye generated output return karta hai
`AITABLE`	prompt plus optional context range	Headers ke sath poori 2D table return karta hai
`AIREVERSECALC`	50 source cells	Ranked candidate table return karta hai

Important Limits

Formula names AI... bina dots ke use karte hain, jaise AIASK, na ki AI.ASK.
Custom formula functions sirf Google Sheets™ me uplabdh hain.
Formula outputs sirf plain text hote hain. Agar aapko baad me formatting chahiye to AI Agents use kijiye.
Google Apps Script custom functions ki hard 30-second execution limit hoti hai.
AITABLE aur AISPLIT ka spill area bada ho sakta hai. #REF! se bachne ke liye pehle pura output area clear kijiye.
AIREVERSECALC A1-style references ko text ke roop me expect karta hai, jaise "E10" aur "A2:C10".
AIASK ya similar formulas ko 50 alag rows me drag mat kijiye. Ek range formula use kijiye.

Best Practices

$Z$1 me checkbox rakhkar use sabhi AI formulas me [refresh] ke roop me use kijiye, taki one-click regenerate control mil sake.
AIPATTERN ke example pairs ko chhota aur representative rakhiye. 4 se 6 examples aam taur par kafi hote hain.
AISPLIT, AITABLE, ya AIVOCAB chalane se pehle paryapt khali jagah chhodiye.
AIREVERSECALC ko chhote numeric source range par focused rakhiye.
Agar formula timeout ho jaye to dobara try karne se pehle range ko chhota kijiye.

Troubleshooting

Error: Not authorized. Open the add-on sidebar and sign in.
Sidebar kholiye, phir se sign in kijiye, aur sheet ko recalculate kijiye.
Error: AI usage limit reached.
Aapka AI quota khatam ho gaya hai. Reset ka wait kijiye ya plan upgrade karke phir try kijiye.
Error: Range too large. Select fewer rows.
Input is formula ke batch limit se bada hai. Isse chhote ranges me baant dijiye.
Error: AI call failed. Try again later.
Kam rows ke sath dubara try kijiye. Agar problem rahe to add-on ya backend status check kijiye.
#REF!
Spill path me pehle se data hai. Pehle output area clear kijiye.
#ERROR!
Function shayad Apps Script ki 30-second limit tak pahunch gaya. Range kam kijiye aur phir try kijiye.

AI Agents Cleanup, formatting, formulas, aur follow-up prompts ke liye sidebar-driven AI workflows use kijiye.

Language & Settings AI-powered features ko prabhavit karne wali permissions aur settings ko review kijiye.