Forum Discussion
MarkShnier__You
3 years agoQrew 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
------------------------------
- PaulElliott3 years agoQrew MemberThank you MarkSo the Not Blank statement means I have to reverse the logic but I think that'll work.Basically hierarchy would beFC 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.