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
Try:
If(
[Cleared]=0, "Outstanding",
[Cleared] = [Check], "Cleared",
[Cleared] != [Check], "Issue",
"No Status"
)
Looks like the numeric fields are zero if blank.
If(
[Cleared]=0, "Outstanding",
[Cleared] = [Check], "Cleared",
[Cleared] != [Check], "Issue",
"No Status"
)
Looks like the numeric fields are zero if blank.
Good tip. Thanks