Issue with #INVALID REF in formula
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
Answers
-
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.
-
Thank you so much, Paul that worked!
-
Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!