Networkdays with If

I am trying to run the networkdays formula based off a certain status. So what I am trying to accomplish is if the position status shows filled, how long did it take to fill? Here is the formula I am trying and I get the Unparseable error.

=IF([Position Status]@row='Filled',NETWORKDAYS([Submitted to HM]@row, [Overall Position Status Date]@row),[""])

Find more posts tagged with

Accepted answers

Sandhiya07

Hi @mbonner517 ,

Hope you are good and Safe!

Could you please remove the last Square brackets from that formula and use like this,

=IF([Position Status]@row='Filled', NETWORKDAYS([Submitted to HM]@row, [Overall Position Status Date]@row),"")

Thanks,

Sandhiya P

All comments

Sandhiya07

Hi @mbonner517 ,

Hope you are good and Safe!

Could you please remove the last Square brackets from that formula and use like this,

=IF([Position Status]@row='Filled', NETWORKDAYS([Submitted to HM]@row, [Overall Position Status Date]@row),"")

Thanks,

Sandhiya P

mbonner517

Thank you for your response! That worked :)

Sandhiya07

Hi @mbonner517

That's Great!

Please accept the answer if it worked so that status will be changed to accepted.

Thank you!

Have a Good day!

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.