Skip to main content
Question

Concatenated field with color - formula assistance

  • April 21, 2022
  • 0 replies
  • 29 views
Forum|alt.badge.img+11
Please make this work for me.



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

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

[Job - Neighborhood/Subdivision]="540W","<b><font color=#FFCC66>"& $MyConcatenatedFields & "</font color></b>",
$MyConcatenatedFields,)




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

SSNJeffP
Forum|alt.badge.img+11
  • SSNJeffP
  • Registered
  • April 21, 2022
It looks like you have an extra comma right at the end.  Try this:

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

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

[Job - Neighborhood/Subdivision]="540W","<b><font color=#FFCC66>"& $MyConcatenatedFields & "</font color></b>",
$MyConcatenatedFields)

------------------------------
Jeff Peterson
------------------------------
Terms & ConditionsAccessibility statement