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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you @Genevieve P. Yes it runs every Friday.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!