Google Sheets: How to Keep Formula While Adding New Lines to Database
G-Sheet from the video: https://docs.google.com/spreadsheets/...
Financial models: https://www.smarthelping.com
You could be adding new rows to a database with a script / button or from a google form. Either way, this workaround will help you apply formulas to that data on a row-by-row basis without losing the formula reference when new rows are added.
Normally, if you have automation around populating a database and you want to apply formulas to each new row, the google sheet will place a new row that removes the formula. This is how to solve the issue efficiently and keep all the automation for your tracking and reporting needs.
I also added arrays and filters to this free helper.