Flagging a Date 30 days past due?
I have a sheet with the following columns:
- Last Updated: date in which a customer profile was last edited
- Next Review Due: a date calculated as 4 months after the Last Updated Date -- this is the time at which an account team should review the customer profile data to ensure that it is still up-to-date and if any changes are made. A notification is sent out to these folk on this date reminding them of the needed follow up.
Now, I would like to flag any rows which have had a month elapse since that notification was sent out, and no updates recorded.
I'm thinking perhaps via conditional formatting change the Next Review Due date RED if today is 30days or more past, but I'm open to other options.
What formula do I need?
Help Article Resources
Check out the Formula Handbook template!