Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 19, 2022 12:47 PM
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?
Aug 19, 2022 03:05 PM
Something like this might work:
IF(
{Grad Year} - YEAR(TODAY()) < 0,
"graduated",
12 - ({Grad Year} - YEAR(TODAY()))
)
Aug 22, 2022 09:30 AM
Thank you thank you thank you!!