Tickmarks

Question

I have an excel sheet. I have checkboxes in individual cells. Each day has 3 checkmarks under it but i only want the user to be able to put 1 tick mark in the sheet. After a tick mark is added, the other checkmarks need to gray out. But, it has to be where the user can uncheck that tick mark and choose another option.

I dont know how to write code for VMA. So is there an easier solution to make this work?

Answer 1

Could you share a screenshot of your data validation rule?

Answer 2

You may try data validation to limit the checkbox.

Select B2:E4

Data validation rule>Custom>

=SUM(--B$2:B$4)<=1

The rule will limit the checkbox to only one for one column. You will need to uncheck exist one to check another checkbox.

Answer 3

I tried it that way, only using 1 day. It somewhat works if you select fail first, but if you select the other 2 options, it allows you to still add tick marks. Is there an embedded code in that sheet that is preventing it from working?

Answer 4

You should select day by day to apply data validation.

Select G11:I26

Apply this rule.

=Sum(--$G11:$I11)<=1

Then select day 2 range

=Sum(--$J11:$L11)<=1

...

Answer 5

Thanks, but it isn't working for me. When I put the formula in, it works for the 2nd and 3rd column. But, if I check the first column first, i can still put tick marks in the 2nd and 3rd. Another thing I noticed was that the formula is changing on me. Is there something wrong with my format?

working copy of progress report.xlsx