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!
1 Reply
- SergeiBaklanDiamond Contributor
You may use conditional formatting with the rule formula like
=TODAY() - <latest contact> >= x