Creating status using if statement
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 c...
Forum Discussion
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.
[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.