Display negative numbers as Zero and Stop count when complete

Sheldon Solan

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.

Paul Newcome

Are you currently recording the date when the task is marked as complete?

Shelby

Hi Paul, I have a similar scenario but with sums. I'm needing to stop the sum of a number from going negative; it's just a simple cell1 - cell2 - cell3, etc. but I'd like for the number to stop at 0 (never go negative). Any insight would be appreciated.

Paul Newcome

@Shelby You would use a MAX in this particular case.

=MAX(0, current_formula)