This Google Sheets Function Makes Excel Feel Like a Dinosaur
1 min read
Summary
Google Sheets has introduced a new function, AI(), which uses artificial intelligence to complete tasks in its spreadsheet application, competing with Microsoft Excel.
The function currently works with Google’s Workspace Labs and requires an English language Google account.
The function’s syntax is simple, aided by autofill and flash fill, and can be used for a variety of tasks, including text case conversion, extracting email domains and categorising complaints.
However, the function does have limitations and errors can compound when using multiple AI-driven functions.
As the AI model develops and learns, it is expected to become more accurate and widely used.
Rather than replacing traditional formulas entirely, it is likely suited to simpler, lower-risk tasks.
For critical data, manual formula writing is probably safer.
