To prevent the errors that sometimes plague complex calculations, today we’re launching a new setting in 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).
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.
Search the menus from the Help menu
Search the menus while in Compact Controls mode
For more details on these features, please visit the Help Center.
- 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
Gradual rollout (potentially longer than 3 days for feature visibility)
All end users
Change management suggested/FYI
Help Center: Change a spreadsheet’s locale, time zone, calculation settings, and language
Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates