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?
https://1drv.ms/x/s!AvPKf2qE-RGXphNx50P5eTDp3Dry?e=hu1ShL
3 Replies
- 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!
