
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 17, 2022 03:11 PM
Hello-
Any help with if CAMPAIGN THEME is blank, the “-” will not show in the formula?
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}
)
A - B: HOLIDAY PROMOTION - HALLOWEEN -
The theme is Halloween.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 12, 2023 08:15 PM
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
