Tracking stakeholders

Copper Contributor

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


You may use conditional formatting with the rule formula like

=TODAY() - <latest contact> >= x