Adding another IF Condition to my Current Formula

I'm looking to add this condition IF(Status@row <> "Complete", 0, 1) to my overall conditional formula below. Essentially I'm just adding the rule that if the status is complete than the value should be 1. I'm having issues embedding it in my existing formula, any advice?

=IF(ISBLANK(Start@row), 0, IF(Start@row <= TODAY(), NETWORKDAYS(Start@row, MIN(TODAY(), Finish@row)) / Duration@row, 0))

Find more posts tagged with

Formulas

Accepted answers

Kelly Moore

Hey @Ryan Jared

Try this.

=IF(ISBLANK(Start@row), 0, IF(Status@row = "Complete",1, IF(Start@row <= TODAY(), NETWORKDAYS(Start@row, MIN(TODAY(), Finish@row)) / Duration@row, 0)))

Will this work for you?

Kelly

All comments

Kelly Moore

Hey @Ryan Jared

Try this.

=IF(ISBLANK(Start@row), 0, IF(Status@row = "Complete",1, IF(Start@row <= TODAY(), NETWORKDAYS(Start@row, MIN(TODAY(), Finish@row)) / Duration@row, 0)))

Will this work for you?

Kelly

Ryan Jared

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