Help

Re: Conditional IF formatting

Solved
Jump to Solution
2742 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Dalene_Rovensti
5 - Automation Enthusiast
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
Ben_Young1
11 - Venus
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}
        )
    )
)

 

See Solution in Thread

2 Replies 2
Ben_Young1
11 - Venus
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}
        )
    )
)

 

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