IF statement with multiple dropdown column criteria

Platform discussions
,
1

I have used this formula successfully referencing a dropdown column.
if({Design Requirements#Labels}=“1. Engineering”,“E”,if({Design Requirements#Labels}=“2. Foundation”,“F”,if({Design Requirements#Labels}=“3. Detailing”,“D”,“”)
I need to add the following as a nested if function but formula is not returning the correct value.

if(and({Design Requirements#Labels}=“1. Engineering”,{Design Requirements#Labels}=“2. Foundation”),“EF”,“NA”)

2

Hi @aknight,

Simply add another IF statement:

IF({Design Requirements#Labels}="1. Engineering",
     "E",
     IF({Design Requirements#Labels}="2. Foundation",
          "F",
           IF({Design Requirements#Labels}="3. Detailing",
                  "D",
                  IF({Design Requirements#Labels}="1. Engineering, 2. Foundation",
                         "EF",
                         ""
                  )
           )
      )
)

 

Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.

3

Thank you for the response. I see that keeping “1. Engineering, 2. Foundation” in quotes for the argument allows it to look at both dropdown choices for the statement.

Perfect fix.

4

Is there any way to write the if statement so that it does not matter what order the dropdown items are selected?

Example:

  1. Engineering 2. Foundation returns “EF” as wanted but if dropdown is not selected in order like this 2. Foundation 1. Engineering it will not return desired outcome of “EF”
5

If you have only 2 selections to check, try:

IF(OR({Design Requirements#Labels}="1. Engineering, 2. Foundation",
             {Design Requirements#Labels}="2. Foundation, 1. Engineering"),
                     "EF",
                     ""
              )

 

What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.