Hello everyone,
We’re facing a critical issue in one of our Reports.
We use integration and it adds values to the sheets. The corrected values don't seem to auto-save.
Formulas in sheets first show #BLOCKED/Invalid Value, then if we refresh the sheet - it updates to the correct numbers. The save button is active even though we do not make any changes (integration supposedly works at midnight).
Because of this, the report shows #BLOCKED as well until we manually refresh the sheets.
It never happened before when we used integration.
SmartSheet support does not seem to have an answer or solution.
Is there a way to force auto-save after formula refresh or API updates?
SmartSheet team – can this be escalated?
Thank you in advance