Solved: New Bug Encountered: Incorrect DSUM formula when e... - Page 2

timbanks103 · 11-19-2020 04:40 AM

My google spreadsheet contains a column with the formula: =DSUM($A$1:$F,$F$1,{“Product id”;C2}) but when a new row is added by appsheet, the formula is =DSUM($A$1:$F1010,$F$1,“Product id”{;C3}) This results in “Formula parse error.” because the criteria array in parameter 3 is garbled.

The same problem occurs with the functions DMIN and DMAX

This looks like a defect… or am I doing something wrong?

timbanks103

It seems to me that arithmetic formulae are handled correctly, but function calls aren’t always. The bypass in my case is to do calculations on a separate sheet and use arrayformula(VLookup()) in the top row to bring the results back in for display.

View solution in original post

New Bug Encountered: Incorrect DSUM formula when extending table with new row