▲ 2 r/googlesheets
Returning text in a cell based on the numerical value of a different cell
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?
u/Six_factorial — 2 days ago