Sign in to join the conversation:
I am trying to build a UI using Google scripts to display the changes made to any given row.
In other words, I want to capture a list of modified date, modified by and what was changed in a row if any cell in the row was updated.
You *can* make requests for Cell History, but they are expensive and can sometimes take a long time to process. It is much more efficient to use webhooks on the row to flag you when a row has changed. https://smartsheet-platform.github.io/api-docs/#webhooks
Hi community experts, I'm trying to flag projects that are at risk. A project should be marked "At Risk" if the Status is not Complete, the Due Date is within the next 7 days, and the % Complete is less than 80%. Otherwise it should show On Track. What formula can do this?
Hello, This might be somewhat of a long/confusing one. I am trying to figure out how to better automate categorization for blood pressure categories when being placed into a sheet. For example, in the image below the column "BP" is where the initial number is input. I then put a LEFT formula in the column "Sys formula" to…
I’m trying to set up an automation rule in Smartsheet where the “Status” column automatically changes to “In Progress” when the “% Complete” column is updated to a value between 1% and 99%. I noticed that there isn’t a “between” function available when setting conditions in the automation workflow. What is the correct way…
