Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Conditional IF formatting

Topic Labels: Formulas
Solved
Jump to Solution
3073 2
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.