restrict checking check boxes

Options

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.

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    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
    Options

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