I have two fields:
[Audience Primary] which is a Text-Multiple Choice field
[Audience Secondary] which is a Multi-Select text field
I am trying to create a third Formula-text field [Audience] but am having trouble with the formula.
This is what I need to do:
If [Audience Secondary] is blank, show the value in [Audience Primary] only.
If [Audience Secondary] is not blank, show the value in [Audience Primary] and the value in [Audience Secondary] separated by a comma.
So if [Audience Secondary] = Partner; Service Provider
and [Audience Primary] = Customer
I want [Audience] to = Customer, Partner, Service Provider
If it is easier to use a semi colon in between each value, that's ok too
thank you in advance!