Formula

I want to include a column, On Hold, a checkbox (0,1). If it's checked, I want the State to be "On Hold", with another formula that enters State depending on two other cells - Status (RYGB) and % Column.

Unchecked and it should follow the rest of the formula.

How do I combine them?

=IF([On Hold]@row = 1, "On Hold")

=IF(AND(Status@row = "Blue", [% Complete]@row = 1), "Complete", IF(AND(Status@row = "Green", [% Complete]@row = 0), "Not Started", IF(AND(OR(Status@row = "Green", Status@row = "Yellow", Status@row = "Red"), [% Complete]@row > 0), "In Progress")))

Thanks,

Melitta

Find more posts tagged with

Formulas

Accepted answers

Mark Cronk

=IF([On Hold]@row = 1, "On Hold", IF(AND(Status@row = "Blue", [% Complete]@row = 1), "Complete", IF(AND(Status@row = "Green", [% Complete]@row = 0), "Not Started", IF(AND(OR(Status@row = "Green", Status@row = "Yellow", Status@row = "Red"), [% Complete]@row > 0), "In Progress"))))

Mark

All comments

Mark Cronk

Mark

Melitta

Thanks Mark.

I'm wondering why I wasn't able to get them to work together yet it works fine when I copy it from here.

Melitta

Mark Cronk

Hmm. Likely a comma, or typo issue. Glad you found a solution. Thank you for contributing to the Community.

Mark

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.