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.
Blank values are treated as 0 only if this option for the field is selected, "Treat blank values as "0" in calculations". That might be default but not everyone uses the defaults. Probably better to have it calculate as 0 in this case but just something to watch for.