Help

Nested IF for three options

Topic Labels: Formulas
3305 11
cancel
Showing results for 
Search instead for 
Did you mean: 
Dgmknzgrl
6 - Interface Innovator
6 - Interface Innovator

I've spent a fair bit of time looking and IF, AND, OR, SWITCH formulas but can't seem to figure this out for making three different options using two fields with the correct punctuation.

I have two fields, {Full Name} and {Organization}.

If there is just a name, I want 'Full Name'

If there is just an organization, I want 'Organization'

If there is both a name and organization, I want 'Full Name (Organization)'

 

 
This is the least complicated of all the attempts made which seems to work, but I can't figure out how to get the brackets to behave.
IF({Full Name}=TRUE(),{Full Name},(IF({Full Name}=FALSE(),{Organization Name},{Full Name}&" ("&{Organization Name})))&")"
 
And a screenshot of what it looks like. The only one that is correct it the Name (Organization).
 
Name-Org.jpg
 
Thanks in advance!
11 Replies 11

Is it possible that there are spaces in your Full Name field? Because that is one thing that would cause that behavior.....

Yes! My Full Name field is a formula and was generating a space. Thanks much!!