nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

Networkdays and #invalid data error

hdixon100886

Hoping you can help with the below formula. I need to return zero and can not get the iferror formula to work. current formula is =NETWORKDAYS([Agreement Effective Date]4, [Actual Go Live]4). Screenshot included for reference.

Thanks,

Heather

Find more posts tagged with

Formulas

Comments

Andrée Starå

Hi Heather,

The screenshot doesn't show the columns mentioned.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

hdixon100886

Hi Andree,

The screen shot was attached to my original post. I am looking to replace the error message with a 0 when both date fields are not populated. This will most likely occur in column "actual go live" column.

Thanks,

Heather

Paul Newcome

You can just use an IFERROR statement like this...

=IFERROR(NETWORKDAYS([Agreement Effective Date]4, [Actual Go Live]4), 0)

Andrée Starå

Happy to help!

Try something like.

=IFERROR(NETWORKDAYS([Agreement Effective Date]4, [Actual Go Live]4),0)

Did it work?

hdixon100886

This was perfect. Thank you!

Andrée Starå

Excellent!

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

Using HAS function with SUMIF - multiple references
Hi all, reaching out to see if of you have ideas; I'm hoping this makes sense: I'm having some trouble getting my formulas to pull data in correctly. I currently have a sheet (primary data) where I have data in rows where each row is a single project, with columns identifying persons, $ values, unique project identifier,…
Automated Messages Being Truncated- Does anyone have a workaround?
Hello, I have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
How to enlarge cell formula reference limit
I have a sheet with 5000 rows and 30 columns. with 4 columns of them are formular columns. How can i reach this limit for 25000000 formular cells reference? How can i enlarge this limit? I need those formular to link some data from another sheet as there is also Max cells limit for one sheet. How can I join those data…