Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Calculating School Grade Level From Grad Year

Topic Labels: Formulas
142 2
cancel
Showing results for 
Search instead for 
Did you mean: 

We’d like to have something that automatically populates what grade the student is in this year based on their expected grad year (the grad year doesn’t change, and the school grade level changes each year, so trying to avoid having to go back in and adjust the grade level each year…) any thoughts?

2 Replies 2

Something like this might work:

IF(
  {Grad Year} - YEAR(TODAY()) < 0,
  "graduated",
  12 - ({Grad Year} - YEAR(TODAY()))
)

Thank you thank you thank you!!