So I’m making a D&D character sheet for players using dropdown lists and prefills from their selections. I’ve unfortunately run into a small issue with the character size prefill. You see, some races have “Small or Medium” as size options while the vast majority just have “Medium.”
I know how to make a conditional list referencing the race selection, thankfully, but it then presents races with only “Medium” a dropdown instead of just pre-filling. Not the end of the world, I agree, but it’s just been one of those annoyances which just eats away at my perfectionist self. Currently I have:
Data validation (allow list):
=IF(OR(handful of races with options), variable with Medium and Small as selections, “Medium”)
Any thoughts aside from the well-known fact I should just deal with it?