Cross Sheet Formula COUNTIFS Help

Simon Bamford
Simon Bamford ✭✭✭✭
edited 06/20/22 in Formulas and Functions


I have a metric sheet that links people with the status of a project.

=COUNTIFS({Corporate Objectives 2022 Range 1}, [Assigned Started]@row, {Copy of Corporate Objectives 2022 Range 1}, Status1)

[Assigned Started] is the person assigned the project.

[Status1] is the project status.

That formula works no problem when there is only one person but some projects have 2 people in the assigned on the main sheet. So it cannot read these.

Does anyone know how to modify the formula so that it can read either name?

Thank you for the help.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!