Re: Conditional IF formatting

Solved
1986 0
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

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!
1 Solution

Accepted Solutions
11 - Venus

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}
)
)
)``````

2 Replies 2
11 - Venus

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}
)
)
)``````

5 - Automation Enthusiast

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