This is hobby related, so feel free to ignore. I want to learn how to use Google sheets, and am doing so by building a partial DnD character sheet, piece by piece.
I am trying not to use scripts as I don't have knowledge to understand how it's working
I have 10 checkboxes, where each box corresponds with a list. If a box is checked, that corresponding list will appear in an answer column, and multiple checks will add multiple lists as one list in the answer column
How do I populate this answer list using the checkboxes?
When I check a box as true, it returns a named range as a string. I use the indirect function and the index function to make this into a list, but I feel that this is not a good way to do it.
I'm not sure how to paste cells to demonstrate what I mean, so I can only use images sorry.
Also, I now realise Class is mislabeled as Race.