Formula for to change cell value if all checkboxes ticked
Request assistance with a formula for the below scenario.
Eleven of the columns in the Smartsheet have a Checkbox. I am looking for a formula that if all the Checkboxes are ticked then the value on the adjacent cell changes from 'Initiated' to 'Completed'.
I'm new to Smartsheet and Formulas 😃. Your help is greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!