Hello AirTable Community!
We are currently at a stand-still on our sheet. What we were are currently doing is the folllowing:
Check If membership has a member.
If successful, proceed to next condition, if not ,label "No Member"
If Membership has a member, check if the member has no passport passes
If successful, proceed to next condition, if not ,label "Passport Holder"
If successful, check if member currently has passes left
If successful, proceed to next condition, if not, label "For Renewal"
If successful, check if renewal date is less than the date today
If successful, label member as “Active”, if not, label member as "For renewal"
What I’m currently facing is that if the member has passed through the condition for the date checking, and the renewal date is lesser than the date today. It sill labels the member as “Active”, and not "For Renewal"
Any insight on our current predicament is welcomed.
Here’s a link to our sheet.
Here’s the formula for the conditions
IF({Member Details} !="",
IF({Passport Passes} ='',
IF(
{Membership Passes Left} > 0,
IF(
DATETIME_FORMAT({Renewal Date}, 'MM/DD/YYYY') <= DATETIME_FORMAT(TODAY(), 'MM/DD/YYYY') &
DATETIME_FORMAT({Renewal Date}, 'YYYY') <= DATETIME_FORMAT(TODAY(), 'YYYY'),
"Active",
"For Renewal"),
"For Renewal"
),
"Passport Holder"),
"No Member")