Conditional IF formatting

[Dalene_Rovensti]

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!

[Ben_Young1 · Accepted solution]

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]

The first one worked perfectly! Thank you!! I was making that more complicated than I needed to be.