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.
Launch DetailsRelease 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
Editions:Available to all G Suite editions
Rollout pace:Gradual rollout (potentially longer than 3 days for feature visibility)
Impact:All end users
Action:Change management suggested/FYI
More InformationHelp Center: Change a spreadsheet's locale, time zone, calculation settings, and languageLaunch release calendarLaunch detail categoriesGet these product update alerts by emailSubscribe to the RSS feed of these updates
