How to make a number less than 0 show up as 0

I am trying to calculate the number of working days remaining in a project plan, but if the end date is in the past it is showing negative numbers. How do I change this to show a 0 instead of the negative number if the task is complete? This is the current formula I am using: =IF(ISERROR(NETWORKDAYS(TODAY(), [End Date]@row)), "", NETWORKDAYS(TODAY(), [End Date]@row))

Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓

    @Kristin Fortner

    Try this:

    =IFERROR(IF(NETWORKDAYS(TODAY(), [End Date]@row) >= 0, NETWORKDAYS(TODAY(), [End Date]@row), 0), "")

    If the networkdays is 0 or greater, give me the networkdays; otherwise (i.e. networkdays < 0), give me 0.

    (The IFERROR suppresses error messages on rows where you don't have an End Date.)


    Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!