Setting up an alert for a date that is greater than 7 days in the past

steve50951

I am tracking vehicle maintenance for our corporate vehicles. I want to set up a rule that will send an email alert when a repaired checkbox is goes unchecked 7 days from the reported date. There is an option for "in the past (days)". But that doesn't seem to work if the repair date doesnt fit within the "x" # of days you put it. I want it to send an alert it goes unchecked greater than 5 days.

Paul Newcome

If the sheet gets opened daily, you could add a checkbox column and enter

 

=IF(AND(TODAY(-7) > [Reported Date]@row, [Repaired Column]@row = 0), 1)

 

This will check the box if the two criteria are met. You can then base your alert to send for when that box is checked.

steve50951

worked great! exactly what I was looking for. 

Thanks!

 

SGF