- Draft emails: =AI(“Write a concise, professional email opening line to the person in A2, referencing their industry in B2”, A2:B2)
- Extract data: =AI(“Extract only the 5-digit zip code from the address”, B2)
- Fix text: =AI(“Apply proper capitalization, and remove extra spaces from the name in”, B2)
- Standardize dates: =AI(“Standardize the date in B2 to YYYY-MM-DD format”, B2)
- Categorize information: =AI(“categorize amount greater than 80 as ‘Glorious’ and below 80 as ‘Must Improve’, H5”)
When you’ve finished typing your formula, press the Enter key. Gemini will process your prompt and generate a result. The result will be inserted into the cell.
The rightmost column shows the result of an AI prompt formula (shown in the formula bar at the top).
Howard Wen / Foundry
If the data in the reference cell / range is changed, the formula result won’t automatically be updated, but you can select the cell that contains the formula and click the Refresh and insert button that appears to update it.
Applying your Gemini formula to other cells
You can apply this Gemini formula in the cell to the other cells on the rows below it. First, make sure your spreadsheet data is formatted as a table. If it’s not, select all the cells containing data and click Format > Convert to table from the top menu bar.
Click the cell that contains the formula. Then click on the bottom-right corner of the cell (you may see a + sign appear) and drag down to apply the formula to the cells below. Gemini will automatically run the prompt inside these cells, referencing the data from each row that they’re on.
Read the full article here
