If formula question - help! | Airtable Community

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!

Page 1 / 1

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded