Skip to main content
Question

Creating status using if statement

  • July 23, 2019
  • 0 replies
  • 25 views
Building a check register in Quickbase, and want to be able to status checks as either cleared, outstanding, or issue.  Cleared would be when the amount in the cleared field equals the amount in the check field, outstanding would be when their is no value in the cleared field, and issue would be when the amount it the cleared field is not equal to the check amount.
    This topic has been closed for replies.

    • AustinK
    • Quickbase Alumni
    • July 23, 2019
    If(
    [cleared amount] = [check amount], "Cleared",
    [cleared amount] = null, "Outstanding",
    [cleared amount] != [check amount], "Issue",
    "No Status"
    )

    Something like that will do it. You might have to play with the null or the != parts or re-order the lists so the right things get checked first but that should get you much closer. The reason you might have to play with the order of them is QuickBase takes the first True in the formula and runs with it. So you might have to be more explicit on some lines or it might just work as-is.
    AdamKeever1
    Forum|alt.badge.img+2
    • AdamKeever1
    • Quickbase Alumni
    • July 23, 2019
    Try:

    If(
    [Cleared]=0, "Outstanding",
    [Cleared] = [Check], "Cleared",
    [Cleared] != [Check], "Issue",
    "No Status"
    )

    Looks like the numeric fields are zero if blank.







    Terms & ConditionsAccessibility statement