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

AppSheet AppSheet Q&A
,
1

3X_4_d_4dead6eee77a5d1ee19ed47d8583e4ad1eae407f.png
3X_4_d_4dead6eee77a5d1ee19ed47d8583e4ad1eae407f.png746×249 43.5 KB

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

2

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.

2 Likes