Forum Discussion

PaulElliott's avatar
PaulElliott
Qrew Member
2 years ago

Using Text-Multiple Choice fields in a Formula

So I am working on a project where I have multiple plans for a home build.  I am looking to do a conditional formula which looks a the field for SLB Color (Text-Multiple Choice) is pulled from multipl...
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
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
------------------------------
PaulElliott's avatar
PaulElliott
Qrew Member
2 years ago
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.