whatIf
Test hypothetical value changes and see which formula cells are affected. Applies temporary changes, recalculates, shows before/after diff of affected formula cells, then restores the original state. A string value starting with ”=” is applied as a temporary formula. Max 20 changes, max 100 affected cells reported.
Example: { “changes”: { “A1”: 50, “B1”: “=A1*2” } }
| Parameter | Type | Description | |
|---|---|---|---|
changes | record<string, string | number | boolean | null> | required | Map of cell references to hypothetical values (e.g. { ‘A1’: 50, ‘B1’: 100 }) |