Skip to main content
Question

Status Formula Based on Numbers

  • November 21, 2018
  • 0 replies
  • 27 views
Forum|alt.badge.img+7
I want to create a status formula titled "Income Status" with just one option "Over Income"

The fields i am using is titled "Total Number of Household Members" which is a formula numeric field and "Total Monthly Income".

So if the Total Number of Household Members is equal to "1" and the Total Monthly Income is greater than $1264 then change the "Income Status" to "Over Income". 
    This topic has been closed for replies.

    Forum|alt.badge.img+17
    • EvanMartinez
    • Community Moderator
    • November 21, 2018
    Hi Steph,

    In your Income Status field you most likely want something like

    If([Total Number of Household Members]=1 and [Total Monthly Income]>1264, "Over Income", "")
    That way it will evaluate for those two conditions and if they aren't true it will simply stay blank. It might need to be adjusted if your field names are slightly different in your table. I hope that is helpful as a starting point. 
    Terms & ConditionsAccessibility statement