Combine if ISBLANK in an existing formula that pulls percent complete based on duration

I have the formula that pull the percentage complete based on the duration between 2 dates

=IF([Start Date]@row <= TODAY(), NETWORKDAYS([Start Date]@row, MIN(TODAY(), [End Date]@row)) / Duration@row, 0)

What I'm trying to do is add the formula below to make a combined formula. Which should make the number zero if there is no date added.

=IF(ISBLANK([Start Date]@row), "0")

Any thoughts?

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You would drop the first IF in the third portion of the second IF to create a nest IF statement.

=IF(logical statement, value if true, value if false)

Basically you want it to run the first logical statement. If that is true then you have your output. If the first logical statement is false then you want to run another IF statement.

All comments

Paul Newcome

You would drop the first IF in the third portion of the second IF to create a nest IF statement.

=IF(logical statement, value if true, value if false)

Basically you want it to run the first logical statement. If that is true then you have your output. If the first logical statement is false then you want to run another IF statement.

Ryan Jared

That did the trick, Thanks @Paul Newcome

Paul Newcome

Happy to help. 👍️

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.