Problems with using formula to count items in drop down list


Hi I am hoping you can help me out here. I am trying to create a pie chart on a dashboard to display the proportion of technology types that are being serviced. This is a drop-down list with 5 different values. I read it is easiest to count the values individually in the Sheet Summary and then use that to create the chart on the dashboard. If you have a better idea, please let me know.

=(COUNTFS([Technology Type]:[Technology Type], CONTAINS("Computer", @cell))

I am using the above formula but it is coming back as "UNPARSEABLE" Can anyone help? Thanks! @Genevieve P.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!