Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Column with Multiple if conditions

Hi,

Good Day!

I am trying to create a new column that will give me the results below. i tried using the nested ifs or the switch function but is not working. i might have been doing it wrong. below is the data i am working on.

 

if Regionname = Anz, India, Philippines Then "APAC"

if Regionname = Bulgaria, Denmark, France, Germany, Greece, Ivory Coast, Morocco, Netherlands, Poland, Portugal, Senegal, Serbia, Spain, UK Then "EMEA"

if Regionname =Canada, US Then "NA"

if Regionname = Colombia, Mexico, Nicaragua, Panama Then "LATAM"

if Regionname =At Home then "W@H"

else Regionname

 

Thank you so much for the feedback and solutions. 🙂

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • jppv20's avatar
    jppv20
    4 years ago

    Hi Anonymous ,

     

    Thy this formula:

    Column=
    IF(Regionname in {"Anz","India","Philippines"},"APAC",
    IF(Regionname in {"Bulgaria","Denmark","France","Germany","Greece","Ivory Coast","Morocco","Netherlands","Poland","Portugal","Senegal","Serbia","Spain","UK"},"EMEA",
    IF(Regionname in {"Canada","US"},"NA",
    IF(Regionname in {"Colombia","Mexico","Nicaragua","Panama"},"LATAM",
    IF(Regionname = "At Home","W@H",
    Regionname)))))
     
    If I answered your question, please mark it as a solution to help other members find it more quickly.
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    I'd recommend a SWITCH.

     

    Either like this:

    Column =
SWITCH (
    TRUE (),
    Regionname IN { "Anz", "India", "Philippines" }, "APAC",
    Regionname
        IN {
        "Bulgaria",
        "Denmark",
        "France",
        "Germany",
        "Greece",
        "Ivory Coast",
        "Morocco",
        "Netherlands",
        "Poland",
        "Portugal",
        "Senegal",
        "Serbia",
        "Spain",
        "UK"
    }, "EMEA",
    Regionname IN { "Canada", "US" }, "NA",
    Regionname IN { "Colombia", "Mexico", "Nicaragua", "Panama" }, "LATAM",
    Regionname = "At Home", "W@H",
    Regionname
)


    Or like this:

    Column =
SWITCH (
    Regionname,
    "Anz", "APAC",
    "India", "APAC",
    "Philippines", "APAC",
    "Bulgaria", "EMEA",
    "Denmark", "EMEA",
    "France", "EMEA",
    "Germany", "EMEA",
    "Greece", "EMEA",
    "Ivory Coast", "EMEA",
    "Morocco", "EMEA",
    "Netherlands", "EMEA",
    "Poland", "EMEA",
    "Portugal", "EMEA",
    "Senegal", "EMEA",
    "Serbia", "EMEA",
    "Spain", "EMEA",
    "UK", "EMEA",
    "Canada", "NA",
    "US", "NA",
    "Colombia", "LATAM",
    "Mexico", "LATAM",
    "Nicaragua", "LATAM",
    "Panama", "LATAM",
    "At Home", "W@H",
    Regionname
)

3 Replies

  • jppv20's avatar
    jppv20
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi Anonymous ,

     

    Thy this formula:

    Column=
    IF(Regionname in {"Anz","India","Philippines"},"APAC",
    IF(Regionname in {"Bulgaria","Denmark","France","Germany","Greece","Ivory Coast","Morocco","Netherlands","Poland","Portugal","Senegal","Serbia","Spain","UK"},"EMEA",
    IF(Regionname in {"Canada","US"},"NA",
    IF(Regionname in {"Colombia","Mexico","Nicaragua","Panama"},"LATAM",
    IF(Regionname = "At Home","W@H",
    Regionname)))))
     
    If I answered your question, please mark it as a solution to help other members find it more quickly.
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you.. it worked. 🙂

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    I'd recommend a SWITCH.

     

    Either like this:

    Column =
SWITCH (
    TRUE (),
    Regionname IN { "Anz", "India", "Philippines" }, "APAC",
    Regionname
        IN {
        "Bulgaria",
        "Denmark",
        "France",
        "Germany",
        "Greece",
        "Ivory Coast",
        "Morocco",
        "Netherlands",
        "Poland",
        "Portugal",
        "Senegal",
        "Serbia",
        "Spain",
        "UK"
    }, "EMEA",
    Regionname IN { "Canada", "US" }, "NA",
    Regionname IN { "Colombia", "Mexico", "Nicaragua", "Panama" }, "LATAM",
    Regionname = "At Home", "W@H",
    Regionname
)


    Or like this:

    Column =
SWITCH (
    Regionname,
    "Anz", "APAC",
    "India", "APAC",
    "Philippines", "APAC",
    "Bulgaria", "EMEA",
    "Denmark", "EMEA",
    "France", "EMEA",
    "Germany", "EMEA",
    "Greece", "EMEA",
    "Ivory Coast", "EMEA",
    "Morocco", "EMEA",
    "Netherlands", "EMEA",
    "Poland", "EMEA",
    "Portugal", "EMEA",
    "Senegal", "EMEA",
    "Serbia", "EMEA",
    "Spain", "EMEA",
    "UK", "EMEA",
    "Canada", "NA",
    "US", "NA",
    "Colombia", "LATAM",
    "Mexico", "LATAM",
    "Nicaragua", "LATAM",
    "Panama", "LATAM",
    "At Home", "W@H",
    Regionname
)