Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
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")
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")
PhelanSanders
6 years agoQrew Assistant Captain
why does the "This is a duration field" need to be plugged into the formula?