Forum Discussion
Jun01
Apr 10, 2024Copper Contributor
Tracking stakeholders
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!
You may use conditional formatting with the rule formula like
=TODAY() - <latest contact> >= x