Create formula so that when data changes in one cell, it overrides in another

James Fox

Hi there,

I am building a Project Plan and in it, there is a Days To Go column calculated with a formula (=Deadline2 - TODAY()) based on the number of days we have left to complete the task, based on the date we manually input in a Deadline column. And then there is a Status column with dropdown options of Not Started, In Progress and Complete.

Can anyone suggest a formula that would mean when the Status column is changed to Complete, even if the Days To Go Column still has 10 days, for example, this would override the 10 days and also show as Complete?

Many thanks,

James 😊

Paul Newcome

Try something like this...

=IF(Status@row = "Complete", 0, Deadline@row - TODAY())

Paul Newcome

Try something like this...

=IF(Status@row = "Complete", 0, Deadline@row - TODAY())

James Fox

Thanks for your help Paul, that's it sorted!

Paul Newcome

Happy to help! 👍️