Concatenated field with color - formula assistance

Question

Please make this work for me.List(" | ",(ToText([Job - Neighborhood/Subdivision])),[Job - Lot #]);IF([Job - Neighborhood/Subdivision]="Jameson Place","&lt;b&gt;&lt;font color=#948D68&gt;"&amp; $MyConcatenatedFields &amp; "&lt;/font color&gt;&lt;/b&gt;", $MyConcatenatedFields,[Job - Neighborhood/Subdivision]="540W","&lt;b&gt;&lt;font color=#FFCC66&gt;"&amp; $MyConcatenatedFields &amp; "&lt;/font color&gt;&lt;/b&gt;", $MyConcatenatedFields,)------------------------------BuildPro------------------------------

buildpro · Answer

It works!&nbsp; Thank you------------------------------BuildPro------------------------------

jeffpeterson1 · Answer

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",""& $MyConcatenatedFields & "",
$MyConcatenatedFields,

[Job - Neighborhood/Subdivision]="540W",""& $MyConcatenatedFields & "",
$MyConcatenatedFields)

------------------------------
Jeff Peterson
------------------------------

buildpro · Answer

Thank you...this is the error message I get now:------------------------------BuildPro------------------------------

jeffpeterson1 · Answer

Try it like this:List(" | ",(ToText([Job - Neighborhood/Subdivision])),[Job - Lot #]);IF([Job - Neighborhood/Subdivision]="Jameson Place","&lt;b&gt;&lt;font color=#948D68&gt;"&amp; $MyConcatenatedFields &amp; "&lt;/font color&gt;&lt;/b&gt;",[Job - Neighborhood/Subdivision]="540W","&lt;b&gt;&lt;font color=#FFCC66&gt;"&amp; $MyConcatenatedFields &amp; "&lt;/font color&gt;&lt;/b&gt;",$MyConcatenatedFields)------------------------------Jeff Peterson------------------------------

Forum Discussion

Concatenated field with color - formula assistance