CountIFS Multiple Criteria including Checkbox "Checked"

Options

Trying to count if column 1 contains a Checked Checkbox and another column on the same row contains a specific value?

Recieving an Unparsable error...

=COUNTIFS({Mandatory Delivery}, =1), {Current Project Phase}, CONTAINS("1 - Engage", @cell))

any ideas?

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    Hey @Jimthegem

    The unparseable comes from closing the COUNTIFS function too soon. All of the criteria you listed is part of the same COUNTIFS query.

    =COUNTIFS({Mandatory Delivery}, =1, {Current Project Phase}, CONTAINS("1 - Engage", @cell))

    cheers,

    Kelly

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!