Using countif to select an option from a column

I have multiple selections in a column and when I tried to use countifs, it will not pick up the label that is combinated with other options.

For example, in Column B, I have following look up values - Role 1, Role 2, Role 3, etc, but some rows have two or more roles - so in one row, it will say role 1, role 3. In another grid, I would countif from that column B = =countifs ({Letter}, TRUE, {Role}, "Role 3"), it will not pick the row with Role 1, Role 3.

How do I make sure I also pick up the row with Role 3 with other options


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!