Check box formula help!

snhawkin

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!

Paul Newcome

You can set up a Clear Cell Value automation to do this.

Paul Newcome

You can set up a Clear Cell Value automation to do this.