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.

Find more posts tagged with

Accepted answers

All comments

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)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.