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

Find more posts tagged with

Formulas

Project Management

Media & Entertainment

Comments

Andrée Starå

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

Mike Wilday

Yes! Just wrap your formula in an IFERROR function.

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

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.

Mike Wilday

Have it your way, don't get crazy

CB_OSG

Perfect. Thank you very much!!!

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée

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

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.

Paul Newcome

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

Sign in to join the conversation!

Quick Links

Trending discussions

Help for INDEX/COLLECT with multiple criteria
Hi everyone! I usually use INDEX/MATCH, but I am trying to "match" multiple criteria and found that it is better to use INDEX/COLLECT when dealing with multiple criteria. I keep returning "#INVALID VALUE" and am confused what I am missing… I have an "Audience" sheet my team is using with employees' respective name, ID…
How to count if checkbox is checked
Hi, I need to count the total number of items that are in progress that are green but I only need it to count the ones where that criteria is met and a checkbox is not checked. I know the formula below works for counting just those in progress and green but I'm struggling to add the checkbox portion to it.…
Outo populate a field on a form when the form is being fill out
hi, is there a way that in a form i can have a way to outo populate a section (let say name ) when the fill out their information. Specially if I already have an IF function that does it in the background? For example: if the person adds a specific number it will show am specific name, pulling it from the the IF cell in…