restrict checking check boxes

Vinton Douglas

I have two columns with check boxes which I share with users. I want users to be only able to select one and not both. in other words if they check a row in column A, it prohibits them checking the corresponding row in column B. Any help would be appreciated.

Kelly Moore

Hey @Vinton Douglas

How are your users inputting the data? From a form, from a sheet, from a dynamic view…?

If they are directly using the sheet, there is no great way to limit access. Locking a column for one person means you might lock it out for someone else that actually needs Column 2. The best you might be able to do is to use conditional formatting to black out the column you don't want used. Most people will ignore black cells. Create a rule that if column 1 is checked then Column 2 has both black background and black font.

If you are using a form, you can hide column 2 if column 1 gets checked. If you are using Dynamic view you can also hide/show/permit editing as required

Do any of these suggestions seem like they might work for you?

Kelly

Vinton Douglas

Many thanks kelly. I believe conditional formatting will work for me.