Hey
I need to create a button, when clicked it should do autosum of predefined cells.
How do i do that? what script?
Hi @Alinea_Avi
You donโt need to create a button for this.
This is a calculation, so it can be made with Virtual column.
Basically, just a column you add to your table but which is not written on your sheets, that will make all calculation needed.
Typically, if you have a parent/child relation with two table (ex:Order, and line items with cost associated)
than your column [orderSum] will be:
SUM([Related LineItems][Cost])
More here:
Hi @Alinea_Avi
That is not the way AppSheet works.
If you need to do so, I suggest you make a formula in another sheets through an IMPORTRANGE() or QUERY() or whatever fits your need, function, then a SUM().
I suggest:
={"Total col4";SUM(QUERY("sheetAndRangeWhereYourDataAre", col4))}
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |