I would love to see the ability to format text with formulas. Bolding, italicizing, and underling would all be extremely helpful when trying to use formulas to build dynamic rich text descriptions within tables.
Ideally it would look like [Table].Titles.ToBold() to get the results I would be most interested in.
Hi @Nick_Storrs, solution posted by @Johg_Ananda is nice and works until hidden formulas will be supported, so hopefully for some time, but i thought that maybe if you use table formatting you can achieve, at lest partially a similar result, could it be?
@Matthew_Shane You can hack this by creating a table with your ‘format styles’ - make one of them be {1} and style it as a h1, h2, etc. Then use format() to format your text with that style. Its a little clunky but will work!
@Johg_Ananda hi, sorry if this is a few years old, but could you explain this? i’m struggling to make it work. how do you set up the columns in the table, and then reference them for the format() formula?
If the template text has formatting set for the {1}, {2}, {3} … placeholders (like headings, bold, underline, font colors, etc), then the replacement TEXT will inherit that formatting as well.
This lets us create and build up formatted text without having to use hidden (i.e., unsupported) formulas. And it lets regular users edit the TEMPLATE text without having to know Coda Formula Language.