I'm working on a D&D character sheet and i'm attempting to semi-automate spell preparation by marking the spell preparation to "TRUE" and then having a cell that checks how many of those spell preparation cells are set to "TRUE" so that I know how many I have prepared. Is there a feasible way to make this work?
I am trying to make an automated character sheet for my D&D character and I've made pretty good progress, but I have hit a bit of a wall. I have an ability that changes and develops as I level up, including the name of the ability. I want to try and have the cell that defines the ability's name to be able to return the appropriate name based on the numerical value in the cell that defines my level. I'm having a hard time even finding a function to return specific text at all, much less change it based on a numerical value. Is this not possible at all or is there a scuffed way to manage it I'm not thinking of? Or best case, is there just a function I'm missing?