Display negative numbers as Zero and Stop count when complete

I have a Smartsheet which I have a column that is counting the remaining days until the target due date.

=[Target Finish]@row - TODAY()

I would like for the remaining days to stop counting once task is marked as "Complete" in status column. I am also interested in preventing the number count from going negative and just show "0" if the task is past due.


Thank you in Advance.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!