Solved: Show missing Receipts Numbers

Thomas_Varghese · 10-23-2020 03:20 AM

I need an expression to pull out missing number of receipts. Receipts are entered manually in a form.
Lets say the receipts start from 100 and to run in sequence like 101,102 and so on. If the user misses say 103,107 to fill in, how to pull this and show in App in a view as receipts not yet filled in…the user is supposed to fill in sequence manually. In the spreadsheet you can do it with if and countif function…but how to do with expressions in AppSheet.
Thanks

Steve

That spreadsheet is not well suited for use with AppSheet. Notably, the Used column.

A suitable replacement expression would be:

IFS(NOT(IN([Series], table[Used])), [Series])

replacing table with the name of the table in the app.

See also:

View solution in original post

Steve

What would the COUNTIF() formula look like?

Thomas_Varghese

A Col the series, B used ,the third Col D Misssing
Formula Used
If (countif(B$2:B&10,A2)=0,A2,""),
drag this formula down .
How to recreate formula like this in appsheet View.
@Steve

Steve

That spreadsheet is not well suited for use with AppSheet. Notably, the Used column.

A suitable replacement expression would be:

IFS(NOT(IN([Series], table[Used])), [Series])

replacing table with the name of the table in the app.