New iterative calculation settings and more in Google Sheets

To prevent the errors that sometimes plague complex calculations, today we’re launching a new setting in Google Sheets on the web (File > Spreadsheet settings > Calculation > Iterative calculation) that allows you to set the maximum number of times a calculation with a circular reference can take place. In addition, you can specify a “convergence threshold,” and when results from successive calculations differ by less than that threshold value, the calculations will stop (even if the maximum number of calculations has yet to be reached).
iterative-calc-settings- Google Sheets
Over the course of the week, we’ll make additional improvements to your Sheets experience on the web and Android devices. First, we’ll update the Sheets Android app UI to make it easier for users with right-to-left language settings to read and navigate. Second, we’ll make it possible to search the menus in Sheets on the web, much like you can in Google Docs and Slides.
menu-search-1- google sheets


Search the menus while in Compact Controls mode

For more details on these features, please visit the Help Center.

Launch Details
Release track:

  • Launching to Rapid release, with Scheduled release coming on January 9th, 2017
    • Iterative calculation setting
  • Launching to both Rapid release and Scheduled release
    • Right-to-left language improvements
    • Menu search

Available to all G Suite editions

Rollout pace:
Gradual rollout (potentially longer than 3 days for feature visibility)

All end users

Change management suggested/FYI


Reference by