I'm trying to create a formula that will display the full salutation based on other fields (First Name, Last Name, Title, Spouse Name, etc). I thought a nested IF statement would do the trick, and maybe I just missed something, but that generated a big fat ?
Here's what I'm trying to accomplish.
If the spouses last names are different, the result should be <Title> <First_Name> <Last_Name> "&" <Title1> <Spouse_Name> <Spouse_Last_Name> (Dr. John Smith & Dr. Jane Doe)
If they are the same, or there is a Spouse first name and no last name, the result should be <Title> <First_Name> "&" <Soupse_Name> <Last_Name> (Dr. John & Jane Smith)
If there is no spouse information, the result should be <Title> <First_Name> <Last Name> (Dr. John Smith)
The current formula is Evaluate ( "Name_First & \" \" & Name_Last" ; [Name_First ; Name_Last] ) and I tried altering that to fit, but that didn't quite work either.
Any suggestions? Thanks!