YehudahGreenber
8 years agoQrew Assistant Captain
Colored text from formula field, when displayed in another field using the ""Part"" function, does not display in color.
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?
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?