I have the following formula in one column of my Excel table:
=SUMIF(Incm!H827:H1038, โ<>yโ, Incm!F827:F1038)
In the Excel sheet, the value shows correctly (eg. โ2406โ).
However, in AppSheet the value is shown as โ0โ, which is incorrect.
Does AppSheet allow me to use SUMIF formulas in my spreadsheet ?
If so, why is it not showing the calculation correctly ?
I am a completely new user and very grateful for any pointers in the right direction.
AppSheet can detect when formulas are firing in your sheet and wait. Once done AppSheet picks up the results from your spreadsheet to show in the app. It doesnโt care about the formulas themselves only about the resulting value and if that value has changed.
To help with the zero value showing in Appsheet, we need to know about what you have down to create your AppSheet app and to display the value.
Check that the Unpd[Unpaid] column in Appsheet is a Number, Decimal or Price type column
Try if the table is set to read only, you might have the update refresh option set at 24hrs
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |