Finding the date that a cell changed value.

Lee_Anderson_Nephos

I wish to look at a status cell and work out whether it has changed in the last 7 days or not. I want to use this as part of a formula so I could say has status changed in the last 7 days yes or no and then be able to use that information with other info to generate reports so we can see where action is required.

Darren Mullen

Hi,

The most straight forward way would be to create another cell that tracks when the status column changes. This can be done by using the "record a date" automation based on when the status cell changes.

Darren Mullen

Hi,

The most straight forward way would be to create another cell that tracks when the status column changes. This can be done by using the "record a date" automation based on when the status cell changes.