I have dynamic sum formulae in a certain sheet making critical calculations for my app. However, if I add an entry in the app, the formula is discontinued yet I want the same formulae applied to the data in the new entries

You probably need an Array Formula. There is LOTS of info in this forum. Just do a quick search.

i tried on though, let me check for more topics. thanks

https://docs.glideapps.com/all/reference/using-sheets/functions/arrayformula Might be useful

thank you so much taking a look now

[image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. 1/ Definition Arrayformula is defined as “a range, mathematical expression using one cell range … Hope this helps.

Thank you so much. I’m learning more about array formulas indeed. Much appreciated

Feel free to let us know if you need help.

Definitely, I do need help. I have 2 separate sheets; one with lists of products and I want them to be summed up depending on category and project in the second sheet. Hence I’m running a dynamic sumif formula to sum up the products. Here is a link with an example of the scenario I’m facing: https://docs.google.com/spreadsheets/d/1XYuuxtlPOgE2h5cwVePRG92urNVr_Qe27Ubxj6Wkc_4/edit?usp=sharing Thank you so much

I just requested access to your Sheet. My email is ariesarsenal@gmail.com.

[image] ThinhDinh: ariesarsenal@gmail.com. Ook, i have just sent you with editing access

How to Keep Formula While Adding New Lines to Database

Ask for Help

ThinhDinh April 7, 2021, 11:12pm 6

Hope this helps.

Topic		Replies	Views
How do you add functions to rows you add with glide? Ask for Help	5	2465	October 5, 2020
Using Arrayformula or similar with Glideapp form submission Ask for Help	2	557	April 19, 2020
Sum formula Ask for Help	9	1966	July 8, 2020
Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help	125	15517	September 9, 2022
Google Sheets Formula Carry Down Ask for Help	13	3707	July 28, 2022

How to Keep Formula While Adding New Lines to Database

Related topics