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

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓

    @A.J.

    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

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓

    @A.J.

    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.

  • A.J.
    A.J. ✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!