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

Contact List showing as a text only
It happened suddenly. It was working last week. I'm using Index Collect to pull a contact as cross sheet reference. But today, I did not see that working well. Usually it has circle beside my name, suddenly it vanishes, and it just contains text. I'm using those other columns to be sent notification, and it doesn't work…
Formula to Convert Scientific Notation to Numerical Value
Hi, I am trying to create a sheet from data that is originally held in .csv files. My goal is to make it so that transferring the data to my sheet should be as simple as just copy and paste. My issue is that two of the fields that I need to copy over are reported in scientific notation (1.3E+004) and I am trying to figure…
Calculating Quarters with a Start and a Finish date
I searched the community and did not see a formula that calculated Quarter based on a Start and a Finish date while also accounting for cases where the year for the Start and Finish date differ. The formula below handles that. A few notes … It assumes that Finish is always >= Start. The entire formula is wrapped with…