Help on an If Then Formula

Options

I have columns with checkboxes showing whether or not a person completed a course. I would like to enter a formula that shows if all the columns checked, then Assured Instructor should show an "X".


Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    edited 01/26/22 Answer ✓
    Options

    Try this:

    =IF(COUNTIFS([Curriculum & Course Design 50]@row:[Data & Evidence Analysis]@row, (@cell = 1)) = 7, "X", "")

    In English, count all the checked boxes in this range of cells, and if the count equals 7, set this cell value to "X", otherwise leave it blank.

    A checked box in a checkbox column evaluates to 1, so that's how the COUNTIFS is determining if the box is checked, because the cell would be equal to 1 if checked, 0 if not checked.

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!