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 "="...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legend... 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