Nested conditional logic in AirTable formulas not working correctly

Other Questions Airtable
1

I’m working with AirTable and trying to create a complex formula but running into issues. I have a database with student information and need to determine eligibility status based on multiple criteria.

Here’s what I’m trying to accomplish:

  • If StudentLevel equals “Beginner”, set status to “Beginner”
  • If StudentLevel equals “Intermediate”, check if LocationCode is “Advanced” or “Intermediate”, OR if CampusCode is “Advanced” or “Intermediate” - if true, set status to “Intermediate”, otherwise “Beginner”
  • If StudentLevel equals “Advanced”, check if LocationCode is “Advanced” OR CampusCode is “Advanced” - if true, set status to “Advanced”, otherwise “Beginner”

My current formula isn’t working properly:

IF(StudentLevel = "Beginner", "Beginner", IF(StudentLevel = "Intermediate", IF(OR(LocationCode = "Advanced", LocationCode = "Intermediate", CampusCode = "Advanced", CampusCode = "Intermediate"), "Intermediate", "Beginner"), IF(StudentLevel = "Advanced", IF(OR(LocationCode = "Advanced", CampusCode = "Advanced"), "Advanced", "Beginner"))))

What am I doing wrong with the nested IF statements?

2

Your formula looks good structurally, but you’re probably hitting case sensitivity issues with AirTable field names and values. I’ve dealt with this before on similar conditional formulas. Double-check that your field names match exactly what’s in your database - spaces and all. Same goes for text values. Try simplifying first - isolate just the StudentLevel checks, get those working, then add back the other conditions. Also watch out for blank values throwing things off. Using BLANK() to catch those usually helps.