This option would he helpful for what my team has created. We have a primary sheet that is the intake sheet for vehicle maintenance and requests, that sheet has a copy row automation to go to an individual vehicle tracker so that we can track additional information about the vehicles. I would like the new rows that get copied into the individual vehicle sheets to go on top so that the team can see the new entry easily and be able to move it to where they need it.
I've seen that this has been an issue since 2022. The fact that it has been nearly 3 years since then and this issue still hasn't been resolved is a huge let down. :(
At the very least, the automation should follow the rules of the recipient sheet (I.E if a sheet populates new rows at the top, then the automation should do the same or if a sheet populates at the bottom, then it should do that).
Having the option to change whether a row is added to the top or the bottom but not being able to for an automation seems like an oversight. Granted, I am super content that I am able to copy a row over at all, but its not useful if it disrupts the current workflow of an existing sheet.
Edit: I just realized that the last time the status was updated was in 2023. 😥
We really need this basic feature added! I want my rows to copy to the top of the other sheet and not have to spend time doing it manually!