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
Joshua,
For the first one is [Finance Disposition] a formula text field that you are trying to create?
If so then it appears you are trying to use a conditional to set the value to the text value of "YELLOW"
Then something like
If([(Text) PipeLine Value Requested]=<500000,"YELLOW","")
This says if the field [(Text) PipeLine Value Requested] is less than or equal to 500000 then the value is "Yellow" other wise it will be blank.
Is this what you are hoping to see?