Trying to have a formula count assigned to and project status for a report

Rosie S.

Hello! I am trying to create a formula for a metrics report that would count both the person assigned to a project from a main project tracker as well as the status in progress. Not sure what I'm doing wrong with the formula as following the prompts, but getting an error.

=COUNTIFS(Assigned to, Name, [Project Status],[Project Status], "In Progress")

Paul Newcome

If the source data is in a different sheet from the formula, your ranges should be cross sheet references.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Rosie S.

Hi Paul,

Thank you for sharing this, but the reference sheet is also causing the error. Any thoughts on what is wrong with the formula?

Thank you again!

Paul Newcome

What error are you getting, and what do you mean the reference sheet is causing it?