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


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 😊

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!