Colored text from formula field, when displayed in another field using the "Part" function, does not display in color.

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have information which goes through several formula fields, and seems to lose it's color along the way. Information, such as "serial numbers", are entered by the end-user  into one of three text boxes: Type One, Type Two, and Type Three.  Each serial number is separated by a comma. Then, all three "types" are combined within one formula text field, [All Serial Numbers in this Project], after checking for other conditions using an "If".
 Each "type" has a unique color, here is the formula : If ([Check for Blank Type 1] = false, ""&[Serial (Type 1)]& ",\n" &"")& etc. for each box. This field displays serial numbers in three different colors, corresponding to the "type".
 Afterwards, the serial numbers are split up into individual fields, using the "Part" function: Part([All Serial Numbers in this Project], 1 , "," ) , with each field containing a different "Part". The problem is that in these individual fields, only "Part 1" retains it's color, any subsequent color displays as black. Is there a better way to color the [All serial numbers in this project] field so that this should not happen?
Photo of Yehudah Greenberg

Yehudah Greenberg

  • 600 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Every field where you want something to show in a particular color will have to have that built into the formula. For example:

<span style="color:blue">blue</span>
Photo of Yehudah Greenberg

Yehudah Greenberg

  • 600 Points 500 badge 2x thumb
I accidentally left out some of the formula.  The original formula box contains  If ([Check for Blank Type 1] = false, "<div style=\"color:Green; \">"&[Type 1 (Cures)]& ",\n" &"</div>")&   etc, with a different color for each "type".  These colors display fine, I would like the very same colors to carry over to a different formula field which selects certain serial numbers using "Part".