Automatically apply formula when adding new row

Learn how to automatically apply a formula in Google Sheets when adding a new row using Array.

Formulas from video:

=ArrayFormula(if(A2:A="","",(C2:C/B2:B)))

[Maximos-mihb]

I really wish you had zoomed in on your sheet. I appreciate you giving the formula in the description, but IMO it would've made the video easier to follow. Cheers.

[NicholasWongCQ]

This guy got glasses himself and he creates a video that even someone that doesn't wear glasses can't see. Amazing.

[HeyNoah]

I can barely see what you're doing 😒 BUT just what I was looking for. Thanks a lot!

[gaby.salazar]

Thank you so much, Edward! Clear & Fast! Bum!

[automatemybusiness]

Noted, will make sure I do this moving forward. Thanks for the feedback

[digitaltools]

Thank you for the video, but what if you a new row from the top and add some numbers, how will that automatically calculate?

[agustok]

bro, can you make it litlle bit smaller

[AK]

Can someone tell how to dynamic add the values of rows like when a new row is added with a new value, then what formula to use so that it automatically picks the value of new row and then show the of all the rows. TIA😊

[PocketSurvey]

Why so small? There is a zoom feature!

[ElizabethGemmell-ssue]

Is there a way to do this with a running balance formula? Specifically, I have a series of deposits and withdrawals in column C, with a running balance of those entries in column E, the formula for which is =sum($C$3:Cx), with x representing the specific row number for a given row, starting at C3. This formula auto-fills the correct value for x just fine, but I would like it to do so on its own, as I frequently add new rows and/or move rows around, and manually auto-filling it takes up a seemingly unnecessary amount of time, especially when I want to make several adjustments at once or when I'm adding new entries. It also causes significant problems when moving rows, because it does not automatically adjust the formula for its new location. When I plugged my formula into your array, it simply outputted the value of =sum($C$3:C3) down the entire column, rather than adjusting x to reflect the current row number. Is there a way to fix that?

[morganleigh]

Hello. How about when you are adding lines above.. and it doesn’t pull the formula for those lines you just added?

[opeciskandar]

hi there. i would like to ask you 1 thing. Is it possible to use this method to copy a command, not a mathematical formula (such as SUBSTITUTE or sort of it)? Really need the answer. Thank you very much for your help.

[neelalam]

How to see what you are trying to show as your screen is not suitable to see without binoculars.

[shanemcelroy]

Any chance you can make the sheet a bit smaller? 😏

[anakhamba]

This is a very terrible way to learn from you!