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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!