Formula help with 2 columns of check boxes

Options

Hi,

I am new to Smartsheet and need some help. The main column is [Customer Name] and all rows below it are different customer names. Next, I have two checkbox columns [Comp. A Ready] and [Comp. B Ready]. I have used COUNTIF formulas to total the number of checked boxes for [Comp. A Ready] and [Comp. B Ready] individually in sheet summary.

Next in Sheet Summary, and what I can't figure out, is how to obtain the number of customers who have [Comp. A Ready] checked and [Comp. B Ready] not checked.

Thanks!

Best Answer

  • jaimelynn0814FEB
    jaimelynn0814FEB ✭✭✭✭
    Answer ✓
    Options

    Would this work? =COUNTIFS([Comp. A Ready]:[Comp. A Ready], 1, [Comp. B Ready]:[Comp. B Ready], 0)

    This formula will give you the count of all rows where "[Comp. A Ready]" is checked and "[Comp. B Ready]" is not checked, effectively counting the number of customers meeting these conditions.

Answers

  • jaimelynn0814FEB
    jaimelynn0814FEB ✭✭✭✭
    Answer ✓
    Options

    Would this work? =COUNTIFS([Comp. A Ready]:[Comp. A Ready], 1, [Comp. B Ready]:[Comp. B Ready], 0)

    This formula will give you the count of all rows where "[Comp. A Ready]" is checked and "[Comp. B Ready]" is not checked, effectively counting the number of customers meeting these conditions.

  • Melissa V
    Melissa V
    edited 06/14/24
    Options

    It worked. THANK YOU! I was missing the comma after the "1" .

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!