Conditional Formula with Date requirment

Im having trouble combing a conditional formula. Both parts work on their own but when I try to join them it breaks.

So far this is what i have

=IF(AND([FINISH]1< [Go live Date]1), IF(Status1 = "In Progress", 1, IF(Status1 = "Not Started", 1, IF(Status1 = "At Risk", 1,0)))))

I'm trying to do a numerical count. If the Finish date is not past the Go live date and the status is either In progress, At Risk, or Not started then the formula should pull 1. If it does not fit these requirements than the formula should pull 0.

Any idea on what I'm doing wrong?

Find more posts tagged with

Formulas

Accepted answers

Mark Cronk

Hi @Ryan Jared

Try

=IF(AND([FINISH]@row< [Go live Date]@row, OR(Status@row = "In Progress", Status@row= "Not Started", Status@row = "At Risk")), 1, 0)

Work?

Mark

All comments

Mark Cronk

Hi @Ryan Jared

Try

=IF(AND([FINISH]@row< [Go live Date]@row, OR(Status@row = "In Progress", Status@row= "Not Started", Status@row = "At Risk")), 1, 0)

Work?

Mark

Ryan Jared

That worked, 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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.