How to sum and get a total based on a specific date?

Is there any way or formula to do this in appsheet?

Please take a look at the sample app below that has records selection based on user input and is principally similar to your requirement. You could further sum those selected records to get a sum.

https://www.appsheet.com/samples/Allow-the-user-to-filter-a-view-based-on-a-form?appGuidString=91266cff-e843-46b8-a42b-3d85afedb37f

You could use a SUM() on the filtered records in teh slice.

3 Likes