Formula

Melitta

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

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

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

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