Control your Gemini Formulas

Learn how to control your Gemini formulas: regenerate results, replace formulas with results, retry formulas on errors, and control the execution sequence of formulas to avoid unexpected costs or prevent loss of data.

📄️ Pause Function

Prerequisites

📄️ Replace formulas with results

Convert Gemini formulas to static values and prevent any further recalculation, either on a selected number of cells or across an entire sheet. If you need to recover the original formulas later, you can use the version history of your Google sheets

📄️ Retry errors

After troubleshooting Gemini for Sheets errors, you can recalculate all Gemini formulas in cells tagged with #ERROR! or #VALUE!.