Help with formula


I am wanting to count the number of drop down items selected in a cell, but I only want it to count in the cell for a specific row.

This is the sheet that i want to count the number of dropdown items from.

This is the sheet that i want the formula written in to return an output. Currently I have =IF(HAS({centers}, Center@row), COUNTM({july}), "") as the formula, but it is showing the total amount of items in each drop down selected for WHOLE list. What I want to see if for BIRMINGHAM = 3; Scottsdale = 4; Beverly Hills = 0

Can someone help?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!