Metric Sheet, Countif value appears even once in column = #UNPARSEABLE
Hello everyone,
I am trying to create a metric sheet, referencing another sheet's column. The column is a multi-select drop down, so I want to include in metric even if its one of many entries in cell. Any suggestions on why my formula is incorrect? Thanks.
=COUNTIF({Sheet - TPM Request Intake KTG}:{Sheet - TPM Request Intake KTG}, CONTAINS Label@row)
Best Answer
-
Try this...
=COUNTIF({Sheet - TPM Request Intake KTG}, CONTAINS(Label@row, @cell))
Answers
-
Try this...
=COUNTIF({Sheet - TPM Request Intake KTG}, CONTAINS(Label@row, @cell))
-
That worked! Amazing. Thanks! So if it is the entire column, I don't need "({Sheet - TPM Request Intake KTG}:{Sheet - TPM Request Intake KTG}"? and what does the @cell do?
-
That is correct. Even if it is NOT an entire column you do not need to do that with cross sheet references. With cross sheet references all of that is already built in when you create the reference.
The @cell tells the CONTAINS function to evaluate each cell within the previously established range on a cell by cell basis. That is the "range" for the CONTAINS function since you already established the range in the previous portion of the COUNTIF.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!