Trying to create a formula to return status of Parent Row
Patti Petitclerc
✭✭✭✭
I'm trying to create a formula in the Summary section of my project plan that returns the Current Phase of a project based on whether the parent row (Phase 0, Phase 1, Phase 2, etc) is marked "In Progress". I'm not sure if it's a COUNTIF, SUMIF or IF formula.
Answers
-
It would be something along the lines of...
=INDEX(COLLECT([Primary Column]:[Primary Column], [Primary Column]:[Primary Column], CONTAINS("Phase", @cell), [% Column]:[% Column], @cell< 1), 1)
-
Thank you Paul! This helped.
-