NetworkDay formula condition question

I'm looking for guidance please and appreciate any input!

I was able to get the NETWORKDAY formula to work by itself. However, I am now trying to put a condition to calculate NETWORDAY if the Project Status is not "Complete". Otherwise, I want it to display the Duration field. It's not erroring, just says the format is not correct.

All these fields are in the Intake sheet

Find more posts tagged with

Accepted answers

Paul Newcome

Based on the new screenshot, it looks like your cell references are missing a row indicator.

[Project Status]@row

Duration@row

All comments

Paul Newcome

Try adding another closing parenthesis after the TODAY() function.

Kathy PPT

@Paul Newcome - Unfortunately, that didn't work. I tried that and then putting parenthesis around [Duration]. I keep getting syntax is wrong.

This original formula does work: =NETWORKDAY([Onboarding Start Date]@row, TODAY())

I appreciate your time/help. Have a great weekend.

Paul Newcome

Based on the new screenshot, it looks like your cell references are missing a row indicator.

[Project Status]@row

Duration@row

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.