Skip to main content
Question

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

  • May 24, 2019
  • 0 replies
  • 15 views
Forum|alt.badge.img+7
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
      This topic has been closed for replies.

      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")
      Terms & ConditionsAccessibility statement