Is there a better way for Notifications when cell has no update?

Cesar Perez

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.

Genevieve P.

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

Genevieve P.

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

Cesar Perez

Thank you @Genevieve P. Yes it runs every Friday.