How to count the number of dropdown labels as "once" on my board?

Platform discussions Special workflows & use cases
,
1

Hello Monday World!
I’'m a monday novice so appreciate this ask.

I’m trying to account for the number of times a “Dropdown Label” appears in each row and then i only want to account for the Label once in a Column with a Summary Qty??

I dont have a good example other than its similar to using a COUNTIF macro in and excel cell searching through a specific column and then having a total column how many times the LABEL was present??

So I don’t know if I need to use a COUNT or maybe using the CONACTENNATE formula somehow or something else??..Not sure as its all new logic for me.

Thanks! :grinning:

2

Hi Rich,

Your question is not really clear. You may want to add an example and screenshot to make it clearer.

As far as counting the number of labels in a dropdown column is concerned, you can use this formula:

IF({Dropdown}="",0,1+LEN({Dropdown})-LEN(SUBSTITUTE({Dropdown},",","")))

In other words, since {Dropdown} returns the labels separated by commas, you compare the length of {Dropdown} with the length of {Dropdown} one the commas are removed. You add 1 and you get the number of labels. This only if {Dropdown} is not empty.

Hope it helps. As far as your other questions are concerned, I am not sure what you mean so you may want to provide more information.

What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.

3

@GCavin Thanks Gavin for the reply to help…ok, let me try with an example:

Challenge: I need a way to report “once” which of fruits appear on the board?

Yes, I could make a Formula column for every fruit and count them but i don’t need quantity, i need to tell me the number of fruits that appear on the board (so in this example i have 4 different fruits)…I want to know how many of my 4 fruits show up on my board?

My Fruit Labels are: Apples, Pears, Grapes, Bananas

          **Column-A**

Item1 - Apples
Item2 - Bananas
Item2 - Apples, Bananas
Items4 - Bananas

So i want my answer to be = 2 of the 4

I suspect i need multiple fruit columns and then a formula column to concatenate them maybe…something :man_shrugging:

thank you! Rich