Appsheet doesn’t support auto compute for sumif on googlesheet formula.
googlesheet formula : =SUMIF(Sale!$E2:$E,“>=”&Sale!$J$1,Sale!$H2:$H)
2 column [Sale Date] & [Total Payout]
How to make this compute on appsheet?
I want it to sum all the numbers in 1/1/2020-12/30/2020.
Welcome to the AppSheet community.
First_Yo:
How to make this compute on appsheet?
Please take a look at the following help articles. The articles have some relevant examples to your requirement also.
Also please take a look at the following post thread that has many useful topics.
[Guide on How To Create a Community Post](https://community.appsheet.com/t/guide-on-how-to-create-a-community-post/35855) Tips & Tricks ?
Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…
FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks ?
How do I do SUMIF() or SUMIFS()? SUM( SELECT( Orders[Total Amount], AND( ([Customer] = [_THISROW].[Customer]), ([Order Date] >= [_THISROW].[Order Date]) ) ) ) Use SELECT() to gather values from a single column only. See also: AND(), SUM()