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
-
Are you currently recording the date when the task is marked as complete?
-
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.
-
@Shelby You would use a MAX in this particular case.
=MAX(0, current_formula)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!