Skip to main content

Help with nested if

  • January 14, 2023
  • 3 replies
  • 46 views
E
Forum|alt.badge.img+3

I can not get this formula to work.... is it completely wrong or am I missing parathesis? 

 

IF({PMID}=“BathJR”,"Jason R",IF({PMID}=”BathSS”,“Stuart S",IF({PMID}=”BathBL”,“Brian L",IF({PMID}=”ODLBL”,“Brandon C",IF({PMID}=”WINBL”,“Evan V",IF({PMID}=”ODLJR,“Brandon C",IF({PMID}=”WINJR”,“Evan V"))))

    3 replies

    pressGO_design
    Forum|alt.badge.img+21

    I count 7 IFs, so you should have 7 closed parentheses at the end, not 4. Also, sometimes Airtable can get snippy about not have a closing ‘value if false’ at the end of a bunch of nested IFs. If adding the extra parentheses doesn’t work, you may need to add that at the end. 

    Having said that, this is a great candidate for a SWITCH instead of multiple nested IFs. 

      E
      Forum|alt.badge.img+3
      • Erica_Holleran
      • Author
      • New Participant
      • January 14, 2023

      SWITCH worked perfect - thank you!

        pressGO_design
        Forum|alt.badge.img+21

        Yay!

        Terms & ConditionsAccessibility statement