Issue with #INVALID REF in formula

melisaozdeniz

Hello,

I am trying to create a calculation that will then be used for a metric widget on my dashboard. I want to be able to have metrics for different groups of projects by state. My goals is for the formula to only count projects that have "P2P(Department)" in the Department column of my portfolio metadata sheet. I have used this formula before but never had a value that includes parentheses. Any helps figuring out how I can fix this error would be greatly appreciated!

=COUNTIFS({Training - Portfolio Metadata Department}, "P2P (Department)", {Training - (Portfolio Metadata) State}, Symbol@row)

Thanks,

Melisa

Paul Newcome

Double check that you have created your cross sheet references properly. If you click anywhere in between the curly brackets of a cross sheet reference, it should say "Edit Reference" in the formula helper box. If it says "Reference Another Sheet" then the cross sheet reference still needs to be properly created.

melisaozdeniz

Thank you so much, Paul that worked!

Paul Newcome

Happy to help. 👍️