Adding Rows

[Shmuel_Munitz]

Hi, my google sheet has sum ifs and interactions between pages. But when I add a row to my sheet via is there a way to get that sum if cell to be added to the row as well? Otherwise my app will not be very usefull for me.

[kyleheney]

In order for Sheet formulas to transfer to new rows, ARRAYFORMULAs need to be used. Unfortunately, I think SUMIFs have issues with ARRAYFORMULAs. There was a previous discussion here that might help:

Solution to: COUNTIFS and SUMIFS not working with Arrayformula

Hey Gliders During the past months while working on several Glide Apps I kept encountering the fact that Arrayformula, while incredibly practical, doesn’t work with SUMIFS() and COUNTIFS() functions. There are basically 2 main solutions: QUERY() is a great alternative in many cases otherwise SUMIF() and COUNTIF() with an & to concatenate several ranges and several criteria works aswell See example here: Hope this helps and happy gliding

[Jesus_Valenzuela_Dia]

Hi @Shmuel_Munitz you should use array formulas. ARRAYFORMULA - Docs Editors Help

[Eric_Penn]

You could use Arrayformula with Sumif…

i.e.

=arrayformula(if(isblank(A2:A),"",SUMIF(Sheet1!C:C,A2:A,Sheet1!D:D)))

[ThinhDinh]

Do you absolutely need those numbers in the Sheet or are you willing to move the logic into Glide computed columns?

[Shmuel_Munitz]

That seems simpler, how would I do that?

[darder]

This may help:

Math Column

[ThinhDinh]

Since you have IF in there, I think it’s a combination of if-then-else and math/rollup columns. If you can describe your use case we may be able to help.