Help on an If Then Formula
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

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

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!

I hope you're well and safe!
Try something like this.
=IF(COUNTIF([Curriculum & Course Design 50]@row:[Date & Evidence Analysis]@row, 1) = 7, "X", "")
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Thanks for the quick reply. It didn't seem to work, still receive an unparseable error.

Thank you @Jeff Reisman! That worked. I very much appreciate the explanation of the formula  very helpful.
Help Article Resources
Categories
Check out the Formula Handbook template!