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
Don,
Thank you! This placed me on the right track. But I need to use both [Finance Disposition] and [(Text) PipeLine Value Requested] in the formula.
For instance, if the [Finance Disposition] is blank and [(Text) PipeLine Value Requested] is >$500k then the value is "Yellow."
How would I combine both fields into the formula?