▲ 1 r/googlesheets
Sheets is insisting that 6 = 1-5
Title says it all. Why is it insisting this is the case? How do I tell it to stop?
u/Six_factorial — 4 days ago
▲ 2 r/googlesheets
How to have one cell return the number of cells in a range that return "TRUE"
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?
u/Six_factorial — 5 months ago
▲ 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 — 5 months ago