Reminders: How to set up reminder if cell DOESN'T change?
I want to set up reminders, and force and escalation, if a Status cell does not change after X days.
Scenario: Someone fills out an intake form. The Status is "Not Started" by default at the time the Intake form is submitted. The team's SLA is 3 days to change the status to "Reviewed" or "In Progress." If they don't, I want the team to receive a message encouraging them to review the new form.
The problem I am finding is that workflow actions are based on things that have changed/added or on a specific date. Also, the "Creation Date" is not a selectable field in the Date condition because, I'm assuming, it doesn't change--not variable.
Any help with this would be appreciated.
Thanks,
Cash
Best Answer
-
Create a field that checks if both the created date is more then 3 days ago and the status is "Not Started". Then have an automation run every morning that is filtered to this field being checked.
Example formula:
=IF(AND(Status@row="Not Started",(TODAY()-[Created Date]@row)>3),1,0)
Answers
-
Create a field that checks if both the created date is more then 3 days ago and the status is "Not Started". Then have an automation run every morning that is filtered to this field being checked.
Example formula:
=IF(AND(Status@row="Not Started",(TODAY()-[Created Date]@row)>3),1,0)
-
Oh, man...this is perfect! Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 443 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives