I have a file with two workflows. The first workflow is an update request which is sent on Thursday's. The other workflow is to notify the owner if a cell was not updated as requested. To trigger this workflow I created the following helper columns:
Modified: auto number with date formula
Modified date: date only from the Modified column
Today Date: today's date
No Update on Fridays: This column has the following formula to determine if the cell was updated on Thursday or Friday.
=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 checks the Modified Date column to ensure it is not the Friday from the previous week. It then checks if the day in the Today Date column is a Friday, and then it checks if the day in the Modified Date is a Thursday. If all of this is true it adds "Updated" to the No Update on Fridays cell. It repeats that process to check if the day in the Modified is a Friday. If true it adds "Updated" to the No Update on Fridays cell. Otherwise, it adds "No update" to the No Update on Fridays cell.
I would like to know if there is a better way to identify if the cell was updated or not. Thank you in advance.
