Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 05, 2020 12:43 PM
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
Solved! Go to Solution.
Jun 05, 2020 01:21 PM
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?
Jun 05, 2020 01:21 PM
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?
Jun 05, 2020 01:27 PM
Thank you so much! This definitely worked! I’m just getting used to doing this.
Best,
R