The workaround I've been using so far is to make a private copy of the sheet, and then that allows me to adjust the size of the cell/zoom/etc. Alternatively, I also used the 'formula bar' method at other times. It's just potentially an issue for if streamers start reacting to it I think, as it's gonna be very difficult for viewers to read along without opening the sheet themselves. Other people viewing the sheet would have workarounds. The other thing is that since '{role} Answers' sheet has these longform answers for all of the jobs in the role, but the 'individual job' sheet ALSO has these same answers, maybe the former is surplus to requirements? Then again, on the 'individual job (BRD)' sheet, that particular answer is hard to read due to it's sheer length. It's only really 'readable' via the formula box trick:



Completely illegible at 100% zoom, and zooming in makes it so the bottom of the cell is off the bottom of the screen (and google sheets sucks and scrolls by one cell per 'scroll interval' instead of a smooth static distance)



See how the answer gets cut off on the right, the cell needs word wrapping but even then it'll potentially look messy due to linebreaks



It's more legible, but still super long


I guess while it's great to have detail, there's such a thing as 'too much detail' and that specific response managed to cross the line. I don't know if it's necessarily a good 'solution' to tell people to make their response fit into a specific character limit. Maybe it's just us getting hung up on aesthetic stuff that doesn't really matter in the grand scheme of things? This specific player clearly feels very strongly about BRD, enough to write that much about it, so I think limiting how they express their feeling about the class to 'say it in X characters or less', something would be lost in the reduction process. Like, I had to reduce what I want for some of the healers because 'what I want' is a lot longer than I put. But while I wanted to summarize, I know there's some detail that was lost in the 'shortening'. If only there was a way to like, click a cell and have it open up in a popup that has it in bigger font.



Like this, but with the cell's contents in a bigger font. Guess the 'Formula Bar' method is the best stopgap solution we have atm. Only other thing that comes to mind is if there was a way to have responses that are over X characters long automatically forwarded to a pastebin, and a link to said pastebin put in the cell in the answer's place. But then who on earth wants to click a link that says 'response too long - click here to open in pastebin', that's a TLDR warning right there