Is there a better way for Notifications when cell has no update?
I have two workflows in my file. The first is an update request sent on Thursdays. The other is to send a notification to the sheet owner if the cell does not have an update. To determine if the cell does not have an update I created the following helper columns: Modified which is auto number with date format, Modified Date which is the date only from the Modified column, No Update on Fridays which has the following formula:
=IF(OR(AND([Modified Date]@row >= [Today Date]@row - 6, WEEKDAY(TODAY()) = 6, WEEKDAY([Modified Date]@row) = 5), AND([Modified Date]@row >= [Today Date]@row - 6, WEEKDAY(TODAY()) = 6, WEEKDAY([Modified Date]@row) = 6)), "Updated", "No Update")
The formula looks at the Modified Date column to ensure the day is not a Friday . It then checks if Today is a Friday and the Modified Date is a Friday as well. If so, then It labels the cell as "Updated". It repeats the process in case the update was done the previous Thursday. If so, it labels the cell as "Updated". Otherwise, it labels the cell as "Not Updated" and triggers the workflow.
I would like to know if there is a better way to trigger the workflow. Thank you in advance.
Best Answer
-
Hi @Cesar Perez
I presume then that your workflow is a time-based workflow that runs every Friday, and has a Condition Block that says only send out a notification if the formula column says "No Update", is that correct?
If so, this is similar to what I would do! Looks like you've done a great job.
Cheers,
Genevieve
Answers
-
Hi @Cesar Perez
I presume then that your workflow is a time-based workflow that runs every Friday, and has a Condition Block that says only send out a notification if the formula column says "No Update", is that correct?
If so, this is similar to what I would do! Looks like you've done a great job.
Cheers,
Genevieve
-
Thank you @Genevieve P. Yes it runs every Friday.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!