Forum Discussion

PhelanSanders's avatar
PhelanSanders
Qrew Assistant Captain
6 years ago

I Need a Formula Text Field titled Eligibility with 2 possible options (Eligible and Ineligible).

I Need a Formula Text Field titled Eligibility with 2 possible options (Eligible and Ineligible).  Someone is eligible based on ALL of the following responses Eligible  1. [Are you a Resident...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
Try this

IF(
[Are you a Resident] = "Yes"
and
([# of days since last service] >= 365 or IsNull([This is a duration field]))
and
[Are you at least 30 days behind on Rent] = "Yes"
and
[Age] > = 18, "Eligible", "Ineligible")
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
try this

IF(
[Are you a DC Resident?] = "Yes",
[# of days since last ERAP services] >= Days(365) or IsNull([This is a duration field]))
[Are you at least 30 days behind on Rent] = "Yes"
[Age] > = 18, "Eligible", "Ineligible")