Forum Discussion

Del's avatar
Del
Qrew Cadet
5 years ago

Formula Text field based on number field

I performed this via dynamic form rules in the past but want a formula text field for the following conditions, If [Total Number of Members in the Household] = 1 & [Total monthly income] is equ...
Formulas and functions
PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
5 years ago

If([Total Number of Members in the Household] = 1  and  [Total monthly income] >=$1329.17 and 
[Total monthly income] < $4529.17,  "Eligible",
[Total monthly income] > $4529.17, "Ineligible",
[Total Number of Members in the Household] = 2  and  [Total monthly income] >= $1795.83 and
[Total monthly income] < $5175.00,  "Eligible",
[Total monthly income]  > $5175.00,  "Ineligible")



------------------------------
Paul Peterson
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago

    I think that Paul's formula needs to be adjusted

    If(
    [Total Number of Members in the Household] = 1  and  [Total monthly income] >=$1329.17 and 
    [Total monthly income] < $4529.17,  "Eligible",

    [Total Number of Members in the Household] = 1 and [Total monthly income] > $4529.17, "Ineligible",

    [Total Number of Members in the Household] = 2  and  [    Total monthly income] >= $1795.83 and
    [Total monthly income] < $5175.00,  "Eligible",

    [Total Number of Members in the Household] = 2  and [Total monthly income]  > $5175.00,  "Ineligible")



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain
      5 years ago

      Great catch, thanks Mark!



      ------------------------------
      Paul Peterson
      ------------------------------