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.
Thank you for all your help? One follow up question if I wanted to calculate for only checks with a status of Outstanding how many days they have been outstanding how would I filter that. I know the formula would be today() - [check date], but if I don't want a value to calculate for checks cleared how would the filter work