This should do it, but beware of what columns you need to copy down after a new row is created (I assume via a form) and change it accordingly in the part.
sheet.getRange(i-1, 2, 1, 2)
http://bionicteaching.com/google-script-to-copy-row-above-to-blank-row-below/
it works, but then I image now Ive to trigger it…
I changed the script, I removed this test
`` var test = sheet.getRange(i, 2);
Logger.log(test);
//looks to see if the cell is empty
if (test.isBlank()) {
that looks with no sense, when was easier to check if (i= last)
anyway its work
Add an automatic trigger for it, change the event trigger to on change.
I’ve populated rows with previous row data using arrayformulas. Copy and take a look at the MemoriesDetailsLookup sheet in https://rwtsk.glideapp.io/. The navigate columns pull previous row and next row values. There is a little extra in the formula to handle my needs, but this should give you an idea.
Thank you Jeff appreciated.
My needs was a bit different, but anyway I see your formula is also good.
Thanks so much.
How do you get the “Navigate” feature?
It’s just a Tiles style inline list that uses a relation. The data for the relation is built using formulas in the sheet. I explain it below, but you can copy the app and take a look for yourself.