restrict checking check boxes
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
-
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
-
Many thanks kelly. I believe conditional formatting will work for me.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives