Timeline for Adding row to Google Sheets updates SUM formula - I don't want this
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 6, 2020 at 9:09 | comment | added | ADTC |
I have the same problem where if I add a row below the last row in the list, above the total row, the SUM range in the total row doesn't get updated. I often end up using a dummy row above the total which is included in the SUM range and therefore will always ensure any new rows added below the data row, above the dummy row, are included in the SUM range.
|
|
| Jan 19, 2017 at 7:40 | history | edited | serenesat | CC BY-SA 3.0 |
added 8 characters in body; edited title
|
| Jan 18, 2017 at 19:31 | answer | added | ben | timeline score: 2 | |
| Jan 18, 2017 at 19:26 | answer | added | user135384 | timeline score: 0 | |
| Jan 18, 2017 at 19:02 | comment | added | Karl_S | That is row 1, correct? It sounds from your description that the form is adding a row "above" the one where your formula is located. I thought this would have been in row 2 based on your formula. | |
| Jan 18, 2017 at 18:56 | comment | added | ben | Well that header is need to tell me what information is in what column. | |
| Jan 18, 2017 at 18:02 | comment | added | Karl_S | Is the newly entered data placed in row 2? If so, is there any way to change this in the third party form? | |
| Jan 18, 2017 at 17:33 | review | First posts | |||
| Jan 18, 2017 at 17:39 | |||||
| Jan 18, 2017 at 17:32 | history | asked | ben | CC BY-SA 3.0 |