Been trying this for a few hours, trying to fill down column F G H automatically when a new row is added (my data is on another sheet that's coming in from forms) https://docs.google.com/spreadsheets/d/1o19YCQ2EURGAJk9uWa8DfRWoKMhWWBc9OJMWvnLvUqI/edit?usp=sharing Any tips or hints how to get it to fill?
To accomplish this you just need to use an arrayformula:
A word of caution, always delete excess rows in your spreadsheet, in your example you are only using 10 rows of data but your spreadsheet has 1,000 rows, make sure to delete those excess rows so you only have the amount of rows you actually need as using an arrayformula like this will have to calculate every row even though it assigns the rest blank.
answered Dec 13, 2019 at 12:55 CodeCamper CodeCamper 867 5 5 silver badges 7 7 bronze badges Took a bit of trial and error but I got it based on your formula. Thanks! Commented Dec 13, 2019 at 15:31@FelixPau it is better to leave Commented Dec 13, 2019 at 15:46
I was playing with it and couldn't get it to populate down, probably didn't clear the cells below to automatically fill. I updated to your suggestion and fixed the other 2 columns as well, the formula is in the header cell and it fills down. Thanks again!
Commented Dec 13, 2019 at 16:00@FelixPau Great! Glad it worked, sadly or maybe luckily ArrayFormula does not overwrite data so if you ever happen to type in that column accidentally (even if it is identical data) you just need to delete everything below the header and it will automatically fix itself, which is one of the reasons I suggest always having the formula in the header (it allows you to safely delete everything below it)