Forum Discussion
Sorting a Table with Checkboxes
Hello all,
I have what I thought would be a pretty straightforward spreadsheet... It's just about ready to go, but now I'm running into a problem where I'm unable to sort the table and have the checkboxes sorted WITH the correct row. I'm using Form Control checkboxes and I have the "Move but don't size with cells" option selected in the Format Control settings for each checkbox, but it doesn't seem to do anything. Do I need to use the ActiveX Control checkboxes?
I've read that sorting cells with checkboxes can be iffy, but does anybody have any ideas on how to make this work?
Service Instruction Checklist Copy.xlsx
- Did you enter cell values :- Format Control -> Control -> Cell Link = ? ?
Since checkboxes don't add any more information than a "Y" or "X" would--i.e., it's either checked or not--why not just ask your users to indicate "Y" to answer each question in the affirmative. You could use a dropdown/data validation to ensure the answer is not filled inappropriately.
Presumably that would avoid the sorting issues you're encountering.
- I was trying to make it a little easier for tablet use, but I'm starting to think that I may have to go that route instead. Good idea!
