COUNTIFS Formula with multiple criteria including a checkbox

Options

Hello,

I tried multiple formulas and can't seem to figure out to do a count that includes a report code (e.g., OWCA1) and a checkbox. Here is what I have so far:

=COUNTIFS({UHG Risk Control Matrix Range 2}, CONTAINS("OWCA1", @cell), {UHG Risk Control Matrix Range 1}, CONTAINS("1", @cell))

Thank you for any help!!


Best Answers

  • Michael Culley
    Michael Culley ✭✭✭✭✭
    Answer ✓
    Options

    To count the checkbox you wouldn't use "CONTAINS" you would just use 1.

    So it should be

    =COUNTIFS({UHG Risk Control Matrix Range 2}, CONTAINS("OWCA1", @cell), {UHG Risk Control Matrix Range 1}, 1)

    *Assuming the {UHG Risk Control Matrix Range 1} is the checkbox column*

  • MMWegg
    MMWegg ✭✭
    Answer ✓
    Options

    Michael,

    Thank you so much!! It worked perfectly.

    Also, thank you for the quick reply as well!

Answers

  • Michael Culley
    Michael Culley ✭✭✭✭✭
    Answer ✓
    Options

    To count the checkbox you wouldn't use "CONTAINS" you would just use 1.

    So it should be

    =COUNTIFS({UHG Risk Control Matrix Range 2}, CONTAINS("OWCA1", @cell), {UHG Risk Control Matrix Range 1}, 1)

    *Assuming the {UHG Risk Control Matrix Range 1} is the checkbox column*

  • MMWegg
    MMWegg ✭✭
    Answer ✓
    Options

    Michael,

    Thank you so much!! It worked perfectly.

    Also, thank you for the quick reply as well!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!