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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!