How to look across columns with checkbox data type to make them mutually exclusive?
I have 3 columns in my Project Plan that I am using to have team members fill in to indicate if their task is off track, on track, or complete. I only want them to be able to check one of the boxes. Is there a way to look across these 3 columns in a row to meet the following conditions:
- If Off track is checked, clear checkbox for On Track and Complete columns
- If On Track is checked, clear checkbox for Off Track and Complete columns
- If Complete is checked, clear checkbox for On Track and Off Track columns
I tried to write a formula but I couldn't figure out how to do this with columns that have a Checkbox data type. I am also open to an error message. Any ideas on how to accomplish this?
Help Article Resources
Check out the Formula Handbook template!