=COUNTIFS([Project Phase]:[Project Phase], "Readiness", Phase:Phase, "Phase 1", Status:Status, "Complete" / [Project Phase 1 - Readiness]#)

Can anyone please help me solve this problem?

When I have 2 ranges and 2 criterions the formula works, when I increased to 3 ranges and 3 criterions im met with #INVALID OPERATION.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!