Can we add google sheet formula to query?

umit · January 4, 2023, 1:19pm

Hello,

I want to add =SUMIF(B:B;B259;H:H) formula for each new added line.

But it must be changed due to line number of course.
For example for next query it should be =SUMIF(B:B;B260;H:H)

Thanks in advance

umit · January 4, 2023, 2:59pm

Another question
Can i find new query row number?Maybe I can solve this by multipart text

Vladimir_PV · January 4, 2023, 5:24pm

Можно установить любую формулу
You can set any formula

Vladimir_PV · January 4, 2023, 5:26pm

Можно, для этого, выберете поле id которое Вы используете в таблице гугл, и увеличивайте его на единицу

You can, for this, select the id field that you use in the Google spreadsheet, and increase it by one