Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How to force a sheet to fully recalculate via the API
Hi there API Developer community,
I wish to use the API to force a sheet to recalculate.
Currently, we use a report that shows just the first row of every one of our 50 or so project sheets and then we manually copy a new value into a column on that report that we have put aside for the purpose. So, once a value like "Forced update 11-Jan-2017 03:18 PM" is copied down that column on the report and the report is saved, then every sheet shown on that report (appears) to be recalculated.
When I do the same action via the API, it does not appear to have the same outcome (but I am still testing).
Seeking some advice... (and I hope that I have expressed the situation sufficiently clearly)
Thanks in advance,
PS, I just realised that you may be wondering why we need to do this recalculation.
In each of the 50 or so project sheets, there is a column called [Task Status]. [Task Status] shows values including "Completed", "In Progress", "In Progress Early" and "Overdue" and its value is calculated by formula using [Start Date], [End Date], [% Complete], [Row Type] and the function TODAY(). Trouble is that TODAY()'s value is (naturally) volatile.
We have many reports, but one particular report reads every project sheet and shows just the overdue tasks. If a project sheet is not opened for a few days, then the values in its [Task Status] column do not get recalculated and are days out of date. This leads to incorrect decision making. Our goal is to have a program that runs at least once per day and touches (causing recalculation) every project sheet. Thus, all of the reports that rely upon fields like [Task Status] will have reliable information.