Jul 27, 2023 03:57 PM
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)'
Jul 31, 2023 09:16 AM
Aug 02, 2023 11:16 AM
Yes! My Full Name field is a formula and was generating a space. Thanks much!!