Automation to set a checkbox when a number of days is exceeded
I added three columns to my issue tracking smartsheet: "Date set to Accepted/Cancelled" (date) "Days since set Accepted/Cancelled" (count) and "Hide from reporting" (checkbox).
Then I set up two automations: Record date when status changes to Accepted or Cancelled (it works), and When "Days since Accepted/Cancelled" changes to "30", set "Hide from reporting" to "checked" - does not work.
And, if I run (trigger manually) the automation it sets all rows to checked, including rows where "Days since Accepted/Cancelled" is Invalid due to no "Date set to Accepted/Cancelled" or is not "30".
Also, I really wanted to have it trigger at greater than or equal to 30 but could not find that option in the automation.
Answers
-
Hi @Box2105,
Using a condition is probably easier, and there are a couple of options here:
Or:
This second one assumes you don't have any future acceptances/cancellations, but you can add another condition to stop these being falsely ticked if so.
You can easily alter the trigger to run daily at a set time rather than the sheet needing to be open for the values to update if necessary.
Hope this helps - let me know if there are any issues! 😊
-
thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!