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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!