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

@Jun01 

You may use conditional formatting with the rule formula like

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