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.

Paul Newcome

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)

Patti Petitclerc

Thank you Paul! This helped.

Paul Newcome

Happy to help. 👍️