Formula help - if cell range contain any text, check the checkbox, otherwise uncheck

Jamie Null
Jamie Null ✭✭✭
edited 12/09/19 in Formulas and Functions

Hi All,

I'm new to Smartsheet and was hoping someone might be able to help.  I'm trying to build a formula where if a range of cells with that row contain any text, a checkbox is checked.  But if anyone of the cells in that range has not been filled out, the box is not checked.

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!