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>"& $MyConcatenatedFields & "</font color></b>",
$MyConcatenatedFields,

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




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

4 Replies

  • 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
    ------------------------------
    • BuildPro's avatar
      BuildPro
      Qrew Captain
      Thank you...this is the error message I get now:

      ------------------------------
      BuildPro
      ------------------------------
      • JeffPeterson1's avatar
        JeffPeterson1
        Qrew Captain
        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
        ------------------------------