Link to home
Start Free TrialLog in
Avatar of AliciaVee
AliciaVee

asked on

Multiple Conditions in @If formula

Experts,
I know that I'm missing something, but can't figure out what is wrong?  I have a column in a view, and based on what values are available in the documents, I want a specific field to show in the column.  So, I'm using an @If statement.  There are four fields, sometimes only one has a value (at least one will), but sometimes all of them will have a value or only two of them.  So, I've listed what I want to show, based on the order.  But, I can't get it to work -- only the SolicitorName will come up and when that is blank (on the form), the next field BrokerName may (or may not be) blank, but nothing else displays.  At least one of the value of fields after Solicitor is available, but it isn't showing.  What's wrong?

@If(SolicitorName != ""; SolicitorName;
BrokerName != ""; BrokerName;
GAName != ""; GAName;
GAOffice != ""; GAOffice;"")
ASKER CERTIFIED SOLUTION
Avatar of cezarF
cezarF
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of AliciaVee
AliciaVee

ASKER

cezarF,

Yes!  Thank you.  @Trim<fieldname) fixed my problem.  Thanks!!
thanks! :)