Hide Errors Until Cell is Populated

I'm calculating the variance between dates using the following formula.  The problem is that an error is displayed if the Actual Start Date is not populated as show in the screenshot.  

Formula used in Variance Start Date: 

=NETWORKDAYS([Planned Start Date]3, [Actual Start Date]3) - 1

 

Is it possible to have the Variance Start Date cell blank if there is not an Actual Start Date defined by adding something to the formula above? 

Screen Shot 2019-04-16 at 10.05.05 AM.png

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 04/16/19

    Hi,

    Yes, you can add an IFERROR function at the beginning of the formula.

    More info: https://help.smartsheet.com/function/iferror

    Would that work?

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Yes! Just wrap your formula in an IFERROR function. 

    =IFERROR(NETWORKDAYS([Planned Start Date]3, [Actual Start Date]3) - 1, "")

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You can also put it in a regular IF statement.

     

    IF(ISDATE([Actual Start Date]@row), NETWORKDAYS([Planned Start Date]3, [Actual Start Date]3) - 1)

     

    It will have exactly the same result as Andree's and Mike's suggestion above. It's just another option.

    thinkspi.com

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Have it your way, don't get crazy

  • Perfect.  Thank you very much!!!

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Excellent!

    Happy to help!

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Haha. I had opened this thread in a new tab earlier in the morning and forgot to refresh it later when I got a chance to look at it. When I posted my response I saw I was late to the party, so I hurried up and did some quick editing with my *this works the same* disclaimer. Haha blush

    thinkspi.com

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Haha. It's just a good reminder to the community that it's possible to come at a solution from multiple angles and get your results in a variety of ways. laugh

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    So true. Some harder than others when you start over-thinking. Haha.

    thinkspi.com

Help Article Resources