Hey @Scott_Gardner1!
That's one beast of a formula you've got here.
Here's a formatted version of what you originally submitted:
IF(
{CAMPAIGN NAME},
CONCATENATE(
IF(
{CAMPAIGN BRAND},
{CAMPAIGN BRAND} &
IF(
OR({CAMPAIGN NAME}, {CAMPAIGN TYPE}, {CAMPAIGN THEME}, {EVENT NAME}),
" - ",
""
)
),
IF(
{CAMPAIGN NAME},
{CAMPAIGN NAME} &
IF(
OR({CAMPAIGN TYPE}, {CAMPAIGN THEME}, {EVENT NAME}),
": ",
""
)
),
IF(
{CAMPAIGN TYPE},
{CAMPAIGN TYPE} &
IF(
OR({CAMPAIGN THEME}, {EVENT NAME}),
" - ",
""
)
),
IF(
{CAMPAIGN THEME},
{CAMPAIGN THEME}&
IF(
OR({CAMPAIGN TYPE}, {CAMPAIGN THEME}, {EVENT NAME}),
" - ",
""
)
),
IF(
{EVENT NAME},
{EVENT NAME}
)
),
"EVENT" & " - " & {EVENT NAME}
)
I didn't actually get a chance to test this yet, but here's a version of the formula that should fit your requirements:
IF(
{CAMPAIGN NAME},
CONCATENATE(
IF(
{CAMPAIGN BRAND},
{CAMPAIGN BRAND} &
IF(
OR(
{CAMPAIGN NAME},
{CAMPAIGN TYPE},
IF(
{CAMPAIGN THEME},
{CAMPAIGN THEME}
),
{EVENT NAME}),
" - ",
""
)
),
IF(
{CAMPAIGN NAME},
{CAMPAIGN NAME} &
IF(
OR(
{CAMPAIGN TYPE},
IF(
{CAMPAIGN THEME},
{CAMPAIGN THEME}
),
{EVENT NAME}
),
": ",
""
)
),
IF(
{CAMPAIGN TYPE},
{CAMPAIGN TYPE} &
IF(
OR(
IF(
{CAMPAIGN THEME},
{CAMPAIGN THEME},
),
{EVENT NAME}
),
" - ",
""
)
),
IF(
{CAMPAIGN THEME},
{CAMPAIGN THEME} &
IF(
OR({CAMPAIGN TYPE}, {EVENT NAME}),
" - ",
""
)
),
IF(
{EVENT NAME},
{EVENT NAME}
)
),
"EVENT" & " - " & {EVENT NAME}
)
I spiked in some IF functions inside the OR statements that evaluate the presence of a value inside the Campaign Theme field.
If the field is blank, then we skip it. Otherwise, it will evaluate the OR statement and include it
