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
Best answer by kuovonne
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.
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?
+29You 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.
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?
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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.