Google Sheets · Schema

IterativeCalculationSettings

Settings to control how circular dependencies are resolved with iterative calculation.

Google WorkspaceProductivitySpreadsheets

Properties

Name Type Description
maxIterations integer When iterative calculation is enabled, the maximum number of calculation rounds to perform.
convergenceThreshold number When iterative calculation is enabled and successive results differ by less than this threshold value, the calculation rounds stop.
View JSON Schema on GitHub