Can a checkbox be disabled if other checkboxes are clicked?
I have checkboxes in use for scoring to identify priority of a project. Any combination of the first four checks is fine, but checking a box in the fifth column would indicate that nothing should be checked in the first 4 columns. Currently I just have a helper column that turns red and bold if there are certain entries in the total scoring column that don't make sense, but I'd like to prevent the defect of having an inappropriate combination of checks instead of alerting after the decisions have been made.
Is there a way to just disable the click-ability of the "Evaluated but No Scoring Obtained" if any of the other boxes are checked?
Best Answer
-
No. You either have a formula to evaluate things and check or uncheck the box, which requires a formula, or you allow people to manually check/uncheck the boxes.
It sounds like what you need instead is to create a column to monitor what's checked and when boxes 1, 2, 3, and 4 are checked while box 5 is also checked, then maybe it checkmarks it's box. Then you can create an alert automation where if your monitoring box becomes checked it alerts you that someone goofed.
Answers
-
No. You either have a formula to evaluate things and check or uncheck the box, which requires a formula, or you allow people to manually check/uncheck the boxes.
It sounds like what you need instead is to create a column to monitor what's checked and when boxes 1, 2, 3, and 4 are checked while box 5 is also checked, then maybe it checkmarks it's box. Then you can create an alert automation where if your monitoring box becomes checked it alerts you that someone goofed.
-
I made a set of automations that wipes inconsistent checks away when there are incongruous choices made. These same conditions also make an entry in an alert column that advise the user that their entries have been removed due to inconsistencies. That's working for now, but I'd rather just prevent the whole thing by having conditions available to enable a checkbox to be used. #smartsheet... make it happen!
Help Article Resources
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
Check out the Formula Handbook template!