Forum Discussion

Jun01's avatar
Jun01
Copper Contributor
Apr 10, 2024

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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Jun01 

    You may use conditional formatting with the rule formula like

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

Resources