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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!