IF ERROR Help

Hi all,

I am trying to create a formula where I am getting an invalid data error message when dates are not populated. Below is the beginning of my formula:

=NETWORKDAYS([Phase Start Date]44, [Phase End Date]48)

I am trying to add a 0 if there is an error, however I'm missing something in the formula:

=NETWORKDAYS([Phase Start Date]44, [Phase End Date]48), IFERROR([Days to Complete]49:[Days to Complete]97,0)

TIA!

Heather

Find more posts tagged with

Comments

Mike Wilday

Do you want the zero to be added after the number of workdays or in place of it? It's a little confusing what you are requesting. Can you show us what you'd expect in a screenshot from your formula?

Heather Dixon

Hi Mike,

Since there is an error being returned because 1 or both of the date columns do not have a value I would like for the return to be 0. I included two screen shots - one with the return, and one with the error message returned.

Image attached

Work Days Returned.JPG

Heather Dixon

Sorry the first date column should have the "Discovery" date highlighted, and then the second date column is correctly highlighted. Purpose is to determine how many days between Discovery and Go Live.

Mike Wilday

Okay so you can wrap the formula in an iferror tag...

=Iferror(=NETWORKDAYS([Phase Start Date]44, [Phase End Date]48),0)

Should do the trick.

Heather Dixon

Soo I feel like this is Monday LOL....I adding the formula to the appropriate rows and it now returns a "0" for all returns.

Zero Return.JPG

Heather Dixon

I was able to get this one to work!! Thanks Mike

Correction is

=Iferror(NETWORKDAYS([Phase Start Date]44, [Phase End Date]48),0)

Mike Wilday

Whoops. Yep, I accidentally included the equals sign in front of networkdsays! Glad I could help you out.

Sign in to join the conversation!

Quick Links

Trending discussions

Request for Update Report (or something like it)
Hi there! I'm hoping this group can help. I'm building out program/project management & tracking at my company. We have 8 grids (one for each dept) that funnel into multiple reports and dashboards. Within each grid/sheet, there are multiple projects that have CHILDREN project plans nested underneath. We want project owners…
Column with a restricted list very difficult to edit
Hello, I have a column with a restricted list of 100 entries. When I edit the list and scroll to the 50th entry, as soon as I type to change the entry name the column scrolls to the top and I cannot see what I am typing or deleting. I have to keep scrolling back down to the row to see what I have keyed in. Very annoying…
Smartsheet Performance Issue
By when the issue will be resolved?