Is there a better way to send notification if a cell has no update?

12/20/21
Accepted

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.


Best Answer

  • Answer ✓

    Hi @Cesar Perez ,

    Hope you are Good and Safe,

    It will take two more column but if you are okay try this.

    Add two columns for Modified day and today day by using this formula,

    =IF(WEEKDAY([Modified Date]@row) = 1, "Sun", IF(WEEKDAY([Modified Date]@row) = 2, "Mon", IF(WEEKDAY([Modified Date]@row) = 3, "Tues", IF(WEEKDAY([Modified Date]@row) = 4, "Wed", IF(WEEKDAY([Modified Date]@row) = 5, "Thur", IF(WEEKDAY([Modified Date]@row) = 6, "Fri", IF(WEEKDAY([Modified Date]@row) = 7, "Sat")))))))

    or,

    You can directly use this formula for Modified column like this,

    =IF(WEEKDAY([email protected]) = 1, "Sunday", IF(WEEKDAY([email protected]) = 2, "Monday", IF(WEEKDAY([email protected]) = 3, "Tuesday")))

    So at last you can directly get the name of week, then according to your condition you can fix it,

    Ex: =IF([Column name]@row = "Friday", "No Update", "Updated").

    Thanks,

    Sandhiya P

Answers

  • Answer ✓

    Hi @Cesar Perez ,

    Hope you are Good and Safe,

    It will take two more column but if you are okay try this.

    Add two columns for Modified day and today day by using this formula,

    =IF(WEEKDAY([Modified Date]@row) = 1, "Sun", IF(WEEKDAY([Modified Date]@row) = 2, "Mon", IF(WEEKDAY([Modified Date]@row) = 3, "Tues", IF(WEEKDAY([Modified Date]@row) = 4, "Wed", IF(WEEKDAY([Modified Date]@row) = 5, "Thur", IF(WEEKDAY([Modified Date]@row) = 6, "Fri", IF(WEEKDAY([Modified Date]@row) = 7, "Sat")))))))

    or,

    You can directly use this formula for Modified column like this,

    =IF(WEEKDAY([email protected]) = 1, "Sunday", IF(WEEKDAY([email protected]) = 2, "Monday", IF(WEEKDAY([email protected]) = 3, "Tuesday")))

    So at last you can directly get the name of week, then according to your condition you can fix it,

    Ex: =IF([Column name]@row = "Friday", "No Update", "Updated").

    Thanks,

    Sandhiya P

  • Thank you @Sandhiya07. I will try your recommendation.

Sign In or Register to comment.