Hi, can anyone help with creating formula to count how many times iteam appears. I tried to use count(Influencer Name) and it only returns the result of 0
Are you basing the item count of of the item name? Do you also use the Connected column? Which product (CRM/Work Management, etc) and level (Pro/Enterprise) do you have?
Desiree - www.thecleverclovers.com
Theres a limitation with monday where it can only really work horizontally, and not count specific instances vertically.
You can either try using dashboard view with a number counter, OR if you have each person as a dropdown/status column and then group them that way it you will be able to quickly see.
Hi @Giang
It can be done with a marketplace app called the Advanced Formula Booster.
This app takes formulas to another level. Here is how it works:
Here is the formula
The formula reads all the item names in the board, gets their positions in the board, counts the ones similar to the current item name and writes this count (minus 1, to get the count of the other items with the same name, since the current item is included in the count) to the column where the count should be stored.
Two automations are required
Hope it helps.
Hi I’m basing the count, not on the item, but on a column. The column is a formula that extracts name from a connected column. We are now in Monday.com Pro
1 Like