Dear wizards of Airtable,
We run a program for kids this summer. Within a timespan of 4 weeks they can choose which day they’d like to join us. On their last day, they get a “good bye gift”. Unfortunatly this is easily forgotten. Since we run our registration and administration thru airtable I was hoping for you guys might now a solution for this. I’m looking for a formula that kinda goes like this:
IF: only on the last [sign up date] equals [today] status should change to, “good bye gift”
Johny is with us on monday, 4th, 5th and 6th of July. Only on July the 6th his status should change (not the other 2 days).
The “sign up date” field is a multiple-select field. I need a formula (and probably a little detour) that understands which date is the latest date in the sequence.
Thanks in advance!