STRUCTURE: Format Color for Numbers in Formula Columns

Scott Brisbin

Hello,

I'm trying to format a number in a Structure formula column to be red.

The number is calculated and stored to a variable defined as DateDiff.

Since it is a number, I'm converting it to a string using the TEXT function before applying formatting.

"{color:red}TEXT(DateDiff){color}"

The result is TEXT(DateDiff) in red font when I select Wiki Markup rather than the number in red font.  When I remove the formatting, and just return DateDiff as the result in a number format, it returns the expected number. 

There must be a simple error I'm making, but nothing I've tried has worked. 

Thanks in advance,

Scott

Stepan Kholodov

Hello @Scott Brisbin 

If you simply want to display the DateDiff value in red, you can do it with this formula:

concat("{color:red}",DateDiff,"{color}")

I hope this helps. If you have more questions about Structure, please reach out to us directly at our support portal and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)