Forum Discussion
- QuickBaseCoachDQrew CaptainTry 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")- PhelanSandersQrew Assistant CaptainTried plugging it is, it is saying the >= cant be applied on type duration.
IF(
[Are you a DC Resident?] = "Yes",
[# of days since last ERAP services] >= 365 or IsNull([This is a duration field]))
[Are you at least 30 days behind on Rent] = "Yes"
[Age] > = 18, "Eligible", "Ineligible") - QuickBaseCoachDQrew Captaintry 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") - PhelanSandersQrew Assistant Captainwhy does the "This is a duration field" need to be plugged into the formula?