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
Best Answer
-
=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
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
=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
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
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
-
Hmm. Likely a comma, or typo issue. Glad you found a solution. Thank you for contributing to the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
Check out the Formula Handbook template!