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


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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?

  • Paul Newcome
    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!