Hello, an option to add, move, copy, a row to a specific row above or below a user defined row would be an amazing addition. I currently have a task list sheet that has hierarchies to separate different parts of a project. Forms have to be created from field checks and those become the tasks on this sheet. I want to have an automation that does the following;
When “Form 1” is added to a “hidden sheet”, move form row under hierarchy 1 in “Master Task List” sheet,
When “Form 2” is added to a “hidden sheet”, move form row under hierarchy 2 in “Master Task List” sheet,
This image is for a visual reference to follow along.
This would help create much cleaner, organized data lists that can be presentable to clients.