Discussions

Expand all | Collapse all

Formula Field change based on 3-4 fields

  • 1.  Formula Field change based on 3-4 fields

    Posted 09-28-2018 00:30
    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



  • 2.  RE: Formula Field change based on 3-4 fields

    Posted 09-28-2018 11:59
    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")