Help with formula to count multiple select in one cell

scanlan99
scanlan99
edited 02/04/25 in Formulas and Functions

HI! I am hoping to leverage the collective brain power of other smart than myself. I am trying to create a formula via my cross sheet that will count the number of times a contact appears in a cell. What would be even more awesome, would be to count the number of times that an option is within a cell AND the status of that project.

The issue I am running into, is when there is more than one contact in a single cell, it counts nothing. I have tried both the COUNTIF and COUNTIFS but I think this is just above my paygrade to figure out

When more then one division is listed, the COUNT formula does not work.

Formula being used. Although Central Valley and East Bay are entered at least once, they are not counting in the formula.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!