Formula when a column has a checkbox


I cannot seem to find this answer:

When a column has a checkbox, another column must have data in it or it will turn red

Example. If someone is needed on site (it is checked) then a person(s) name must be in the box. They cannot leave it blank or it will be red.

On Site Person

<star> Contact List or cell is RED

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!