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
Check out the Formula Handbook template!