Apr 10 2024 07:44 AM
Hi everyone!
For a project I'd like to track contact moments with stakeholders. The idea is as follows:
There's a column with the latest contact moment date in it. I'd like a formula or something else (if possible) that alerts me when it's been x number of days since the last contact moment. the alerting could be: shifting to the top of the file, or maybe that the cells turn red or orange.
any help would be greatly appreciated!
Apr 10 2024 07:51 AM
You may use conditional formatting with the rule formula like
=TODAY() - <latest contact> >= x