Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
3 years ago

Concatenated field with color - formula assistance

Please make this work for me. List(" | ",(ToText([Job - Neighborhood/Subdivision])),[Job - Lot #]); IF( [Job - Neighborhood/Subdivision]="Jameson Place","<b><font color=#948D68>"& $MyConcat...
Formulas and functions
BuildPro's avatar
BuildPro
Qrew Captain
Thank you...this is the error message I get now:

------------------------------
BuildPro
------------------------------
JeffPeterson1's avatar
JeffPeterson1
Qrew Captain
3 years ago
Try it like this:

List(" | ",(ToText([Job - Neighborhood/Subdivision])),[Job - Lot #]);

IF(
[Job - Neighborhood/Subdivision]="Jameson Place","<b><font color=#948D68>"& $MyConcatenatedFields & "</font color></b>",
[Job - Neighborhood/Subdivision]="540W","<b><font color=#FFCC66>"& $MyConcatenatedFields & "</font color></b>",
$MyConcatenatedFields)

------------------------------
Jeff Peterson
------------------------------
  • BuildPro's avatar
    BuildPro
    Qrew Captain
    3 years ago
    It works!  Thank you

    ------------------------------
    BuildPro
    ------------------------------