Yes, I use it nested in formulas; Rich Text just references the cells containing those formulas. CHAR() is a spreadsheet function, so it has to be outside any quotation marks in your formula.
Is it possible that you are expecting a line break on a Glide element that does not support line breaks? For example, “Details” and “Titles” on inline lists do not support line breaks. So if you have char(10) in your column/cell that is being grabbed by the the Title or Detail field in a Glide list, Glide will simply ignore the break. What you’re trying to do only works on one element currently: RichText. I’m really hoping this will change though… I’m actually using the Title and Details of Inline lists to create a text content feed (like a twitter) and it’s a bummer that you can’t use Markdown or HTML in those elements.
Like @John_Cabrera and @apertur.co said, you can only do line breaks in rich text components, but another thing to try would be 2 spaces and a CRLF (space, space, alt+enter) in place of the char(10). Or at the very least, try just the CRLF (alt+enter), but I think that might not work. If you are trying to do this outside of a rich text component, then it probably won’t work.
Aww, man. I was so hoping you’d found some clever hack there @Jeff_Hager, because having at least carriage returns on those Title, Detail, and Caption fields would be huge for my app. But alas, it still doesn’t work.