Hi everyone,
I was wondering if there is a formula function to count the number of selected items in the Dropdown column. The column itself shows the number, but I want to make some calculations based on number of selections. Dropdown columns return a comma separated list of labels so I can’t use COUNT() (is for numbers) and there are no other text functions (like COUNTA in excel) that I can think
Any guidance is appreciated.
Hello all,
Are there any updates on this ? I would like to count the number of items that is related to a specific value in a dropdown column.
Thank you for your help, have a nice day,
Corentin
Hello all, you can add a formula column and enter {“name of dropdown column”#Count} to count the number of variables in your dropdown column. Let me know if that helps. If not, I can include screenshots.
Happy counting!
Cole
Hi! I’m trying to figure this out too. Could you add screenshots? Thanks!
Hey everyone! @highanddry @corentin.dalfarra @Cole @kzedmonds 
As Cole mentioned, there is an option when including the Dropdown Column in a formula to include either the names of the labels or to count how many labels there are. Selecting the “Count” when building your formula will include the number of labels for that item for the rest of your formula:
Feel free to also check out our formula support articles for more information on how to build different formulas for different use cases:
The IF Function (If you’re looking to make conditional output based on other values on your board).
I hope this helps!
Cheers,
Jenna
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
