Forum Discussion
MarkShnier__You
Qrew Legend
You have not said in words what you want, but it sounds like this but I'm don't know the hierarchy as to what will take precedence. The precedence is set by the sequence of the lines below.
IF(
[FC SLB Color]<>"",[FC SLB Color], // use FC if not blank,
[City Set SLB Color]<>"",[City Set SLB Color], // else use City set if not blank
[Bid Set SLB Color]<>"",[Bid Set SLB Color]) //else fall back to original bid set.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
IF(
[FC SLB Color]<>"",[FC SLB Color], // use FC if not blank,
[City Set SLB Color]<>"",[City Set SLB Color], // else use City set if not blank
[Bid Set SLB Color]<>"",[Bid Set SLB Color]) //else fall back to original bid set.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
PaulElliott
3 years agoQrew Member
Thank you Mark
So the Not Blank statement means I have to reverse the logic but I think that'll work.
Basically hierarchy would be
FC SLB Color (if this exists then use)
City Set SLB Color (if this exists then use if there's no FC)
Bid Set SLB Color (if neither FC or City Set exists then use)
I tried to do a Formula which would pass the textlist result to a formula text result but it must maintain the character attribute of being a textlist result because it was also giving me the same error.