Forum Discussion

JoshuaDavis1's avatar
JoshuaDavis1
Qrew Member
10 days ago

Formula Help

Hello,  I need help combining text fields into a formula(s). Here are my formulas: [Finance Disposition]=""&[(Text) PipeLine Value Requested]="<$500,000"),"YELLOW") I'm getting  the operator "="...
formula query
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
9 days ago

... tag teaming with my buddy DonLarsonThe syntax for the IF statement in Quickbase is much more friendly than Excel because you can list the formula vertically and you don't have to nest all your if statements for subsequent checks.  So usually you just need one IF at the beginning and it will evaluate the conditions in the order they are listed.

IF(

[(Text) PipeLine Value Requested]= "<500000","YELLOW",

[Finance Disposition] ="" and [(Text) PipeLine Value Requested] =  "<$500,000", "YELLOW")

 

// You can list as many conditions as you like, vertically in that syntax and it will keep looking until it finds the first one which is true