How do I get this to work with the IF function formula. Also, I want the text to be colorized, not the background.
thank you
I have used this for another field..but I don't know how to incorporate with the formula in the WALL PAINT field?
var text MyConcatenatedFields =
List(" | ",(ToText([Related Projects - Neighborhood Name])),[Lot #]);
If(
[Related Projects - Neighborhood Name]="Jameson Place","<b><font color=#8e865c>"& $MyConcatenatedFields & "</font color></b>",
[Related Projects - Neighborhood Name]="Freeman Farms","<b><font color=#006633>"& $MyConcatenatedFields & "</font color></b>",
[Related Projects - Neighborhood Name]="Timberleaf","<b><font color=#6ca97c>"& $MyConcatenatedFields & "</font color></b>",
------------------------------
BuildPro
------------------------------
