Formula Help for 2 criteria (checkboxes in two columns) in a CountIfs

Hello:

I keep getting a #unparseable on my formula, so I am guessing it's just a small formatting error. I need to get a CountIFS using two different columns being "checked".

One is "Approval Confirmed" and the other is "Thank-You Made"

This is the latest formula I've tried:

=COUNTIFS([Approval Confirmed]:[Approval Confirmed], 1) AND(COUNTIFS([Client Thank-You Contact]:[Client Thank-You Contact], 1)

Thank you for the help!

-Paula

Best Answer

  • Paula_
    Paula_ ✭✭✭✭
    Answer ✓

    I tried changing the column name as well thinking the hyphen might be the issue.

    Got this to work: =COUNTIFS([Approval Confirmed]:[Approval Confirmed], 1, [Thankyou Made]:[Thankyou Made], 1)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!