Adding IF to a formula with IFERROR

deb_63_hydracor

I'm using the following formula (which works because you all helped me with it!)

=IFERROR(NETDAYS([Date of Verbal Agreement]@row, TODAY()), "")

I need to add "if the "Deployment Complete" box is unchecked but have no idea where to put it in the formula.

Thanks for your help!

Find more posts tagged with

Formulas

Accepted answers

Michael Culley

=if([deployment complete]@row = 0,IFERROR(NETDAYS([Date of Verbal Agreement]@row, TODAY()), ""))

Does that work?

All comments

Michael Culley

=if([deployment complete]@row = 0,IFERROR(NETDAYS([Date of Verbal Agreement]@row, TODAY()), ""))

Does that work?

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.