IF statements for three different criteria including a blank

I am having a hard time with the IF statement. I have a Status category I would like to make student status change based on Anticipated graduation date, however, I don’t have that for all students. So this is the formula I am trying and failing at:

IF(
{Anticipated Graduation Date} <= TODAY(), “Graduated”,
IF({Anticipated Graduation Date} > TODAY(),
"Active Student”,
“Unknown”
)

I’ve done a couple variations and can’t seem to do it. Any thoughts out there??

Thank you,
R

You have to first test if there is an {Anticipated Graduation Date} before you make the other checks. You also have to use date/time functions for comparing dates.

  • Active Student: the {Anticipated Graduation Date} is after today
  • Graduated: the {Anticipated Graduation Date} is today or earlier
  • Unknown: any other situation
IF(
  {Anticipated Graduation Date},
  IF(
    IS_AFTER({Anticipated Graduation Date}, TODAY()),
    "Active Student",
    "Graduated"
  ),
  "Unknown"
)

If this answers your question, please mark this post as the solution. Otherwise, could you please give a bit more details and a screen capture?

Thank you so much! This definitely worked! I’m just getting used to doing this.

Best,
R

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.