Count dropdown selections in one cell

Angela Logie

I'm looking to see how I can add another FIND item to the below formula. Range 6 is a dropdown list and I'm looking to count all entries that have Global AND Mexico in the cell.

The below entry works for just finding anything with Global but I need it to also add anything that also contains Mexico in the same cell:

=COUNTIFS({Go-Live Incident Tracker Range 7}, "1", {Go-Live Incident Tracker Range 6}, FIND("Global", @cell) > 0)

Thanks

Angela

Will.Parente

Have you tried just making those conditions what the COUNTIFS looks for?

=COUNTIFS({Go-Live Incident Tracker Range 7}, "Global", {Go-Live Incident Tracker Range 7}, "Mexico")

Let me know if this works!

Angela Logie

Will,

Unfortunately, this doesn't work, I think its to do with it being a dropdown column/cell. Its giving me a zero return, not an error message but thats not the correct answer.

Thanks

Will.Parente

Angela, no worries. Let's try using Contains Statements:

=IF(AND(CONTAINS("Global", WBS@row), CONTAINS("Mexico", WBS@row)), "1", "0")

https://help.smartsheet.com/function/has

Angela Logie

Will,

Unfortunately this does not seem to work. Its saying its #unparseable: