How to show blank where no data is, when using =MAX(0, NETWORKDAYS(TODAY(), End@row))

Best Answers

  • James Keuning
    James Keuning ✭✭✭✭✭
    Answer ✓

    iferror(MAX(0, NETWORKDAYS(TODAY(), End@row)),"")

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

    @Chris Wash

    There is another method that can come in handy, especially when you have complex formulas, where IFERROR may not be practical.

    You can use IF to give the formula a condition that must be met before it tries the formula, so that it does not try to operate on incompatible cells (like blank ones.) In your case, you don't want your NETWORKDAYS to try to evaluate a cell that is not a date value, because it throws an error. You can use IF and ISDATE to evaluate the "End" cell first to see if it is a date value, and if so, run your MAX formula (and if not, just leave the cell blank):

    =IF(ISDATE(End@row), MAX(0, NETWORKDAYS(TODAY(), End@row)), "")

    The difference between using IFERROR and using IF ISDATE is that IFERROR suppresses error messages, while IF ISDATE prevents the errors.

    Regards,

    Jeff Reisman

    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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!