Hiding #INVALID DATA TYPE with formulas using NETWORKDAYS

Hello, I'd love some feedback and advice on how to get this to work.

I have Start Date, Due Date, Duration and Due in Days columns.

For my Due in Days column I am using this formula:

=NETWORKDAYS(TODAY(), [Actual Due Date]@row)

For my Duration column I am using this formula:

=NETWORKDAYS([Actual Start Date]@row, [Actual Due Date]@row)

My question: How do I hide the error message "#INVALID DATA TYPE" when using the above formulas? Sometimes I have blank cells in the Start Date and Due Date columns so I need to hide the error message.

I'm very new to Smartsheet so if you could provide a full breakdown or formula to plug in using my above formulas I would highly appreciate it.

Thank you!

Find more posts tagged with

Formulas

Accepted answers

SPIPMO

check the closing brackets position @afelo

All comments

Ipshita

Hi @afelo ,

You just need to wrap your formula with the IFERROR statement, like -

=IFERROR(NETWORKDAYS([Start Date]@row, [Due Date]@row), "")

This would return blank where either your start date or due date are blank cells. Hope this helps!

Cheers :)

Ipshita

afelo

Hello Ipshita,

Unfortunately that didn't work. It says #INCORRECT ARGUMENT SET

Any other suggestions?

SPIPMO

check the closing brackets position @afelo

afelo

I was going to comment and say it doesn't work because I tried that yesterday, but I figured I'd give it another shot and it worked! thank you :)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.