Metric Sheet, Countif value appears even once in column = #UNPARSEABLE

Megan Moyer Craig

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)

Paul Newcome

Try this...

=COUNTIF({Sheet - TPM Request Intake KTG}, CONTAINS(Label@row, @cell))

Paul Newcome

Try this...

=COUNTIF({Sheet - TPM Request Intake KTG}, CONTAINS(Label@row, @cell))

Megan Moyer Craig

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?

Paul Newcome

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.