Skip to main content

Retry formulas on error

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

Prerequisites
  • You have opened a Google spreadsheet containing Gemini formulas and selected Extensions > Gemini for Sheets and Docs > Open.
  1. Check that the Gemini formulas aren't paused for your spreadsheet.

Note: To highlight the errors, click on X errors. This will help you identify the Gemini formulas that need correction.

  1. Click Retry errors.

All Gemini formulas that were on error in the current sheet are recalculated. If some errors persist, let us know by submitting a support request.