Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

IF statements for three different criteria including a blank

Topic Labels: Formulas
Solved
Jump to Solution
1161 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Rebecca_Shore
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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?

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

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