Conditional IF formatting

Question

I'm struggling to create the right formula and hoping someone here can help me: I have Field 1 as a single select. It's a list of brands with an "Other" option. Field 2 is a write-in field for when Other has been selected. I'm trying to create Field 3 as a formula field that merges the brand names—both the ones selected in Field 1 drop-down and ones written into Field 2. I have the second half working with ...

IF(Field 1 = "Other", {Field 2})

But I can't figure out how to get the first part merged in. Whenever I try to add to the formula to make it add in the non-other names, I get an error. I tried a second IF formula, like ...

IF(Field 1 != "Other", {Field 1})

But it doesn't work, and I've tried adding CONCATENATE, but I can't get that to work either. I'm not very proficient with formulas, so hoping someone here can help me get what I'm attempting. Thanks!

Best answer by Ben_Young1

Hey @Dalene_Rovensti!

Here are three formulas that all accomplish what you're looking for:

IF(
    {Field 1} = "Other",
    {Field 2},
    {Field 1}
)

IF(
    {Field 1},
    SWITCH(
        {Field 1},
        "Other",
            {Field 2},
        {Field 1}
    )
)

IF(
    AND(
        {Field 1} = "Other",
        {Field 2}
    ),
    {Field 2},
    IF(
        {Field 1},
        {Field 1},
        IF(
            {Field 2},
            {Field 2}
        )
    )
)

View original

Ben_Young1 · Accepted Answer

Hey @Dalene_Rovensti!

Here are three formulas that all accomplish what you're looking for:

IF(
    {Field 1} = "Other",
    {Field 2},
    {Field 1}
)

IF(
    {Field 1},
    SWITCH(
        {Field 1},
        "Other",
            {Field 2},
        {Field 1}
    )
)

IF(
    AND(
        {Field 1} = "Other",
        {Field 2}
    ),
    {Field 2},
    IF(
        {Field 1},
        {Field 1},
        IF(
            {Field 2},
            {Field 2}
        )
    )
)

Dalene_Rovensti · Answer

Hey @Dalene_Rovensti!

Here are three formulas that all accomplish what you're looking for:

IF(
    {Field 1} = "Other",
    {Field 2},
    {Field 1}
)

IF(
    {Field 1},
    SWITCH(
        {Field 1},
        "Other",
            {Field 2},
        {Field 1}
    )
)

IF(
    AND(
        {Field 1} = "Other",
        {Field 2}
    ),
    {Field 2},
    IF(
        {Field 1},
        {Field 1},
        IF(
            {Field 2},
            {Field 2}
        )
    )
)

Conditional IF formatting

2 replies

Reply

Most helpful members this week

Reply

Related topics

Facebook lead ads data not going to emailicon

How to attach 2 pdf files to Outlook emailicon

My Zap was dissolved right after transferring data from Facebook Lead Ads to Google Sheetsicon

Facebook Lead to email addressicon

Issue with transferring emails from Facebook leads to Google Drive using Zapiericon

Most helpful members this week

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded