Creating a formula to count each selection in a cell drop down.

Zcollins1995 ✭✭
edited 02/05/24 in Formulas and Functions

Hello Everyone!

I am looking to edit a formula I am working on to count every option available in a cell. This is the formula I have currently.

=COUNTIFS({2024 Documentation & Projects Range 4}, FIND("CC:", @cell) > 0, {2024 Documentation & Projects Range 5}, FIND("ILT", @cell) > 0)

As you can see, it is only looking for term "ILT", but I would like it to count and selection that pops up in the drop down. I have attached a screenshot of the sheet below.

Any help is appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!