Check box formula help!


I am wanting to set up a formula and/or conditional formatting so that when you check one box, it automatically un-checks another.

example: two columns side by side. one titled "job started" the other titled "job done." I want it so as soon as you check the box for job done, it removes the check from job started. This smartsheet feeds a report, and both cannot be simultaneously checked.

thanks in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!