Formula Field change based on 3-4 fields

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
I Need a Formula Text Field titled Eligibility with 2 possible options (Eligible and Ineligible).

Someone is eligible based on the following responses

Eligible 

1. [Are you a Resident] = Yes
2. [# of days since last service] >or=365 or null
3. [Are you at least 30 days behind on Rent] = Yes
4. [Age] > or = 18


Someone is Ineligible based on the following responses

Ineligible 

1. Are you a Resident = No
2. # of days since last service < 365
3. Are you at least 30 days behind on Rent = No
4. [Age] < 18

Photo of Steph Curry with the Base

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
Try this

IF(
[Are you a Resident] = "Yes"

 and

 ([# of days since last service] >= 365 or IsNull([# of days since last service]))

and

[Are you at least 30 days behind on Rent] = "Yes"

and

[Age] > = 18, "Eligible", Ineligible")