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] = Yes
2. [# of days since last service] >or=365 or null (This is a duration field)
3. [Are you at least 30 days behind on Rent] = Yes
4. [Age] > or = 18


Someone is Ineligible based on ANY of the following responses

Ineligible 

1. Are you a Resident = No
2. # of days since last service < 365 (This is a duration field)
3. Are you at least 30 days behind on Rent = No
4. [Age] < 18
  • 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")
    • PhelanSanders's avatar
      PhelanSanders
      Qrew Assistant Captain
      Tried 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")




    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      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")

    • PhelanSanders's avatar
      PhelanSanders
      Qrew Assistant Captain
      why does the "This is a duration field" need to be plugged into the formula?