This is more of a discussion point and feedback rather than a question. I was experimenting with the Move Row within via a Kanban sprint worksheet. The idea was to move a task into a corresponding History worksheet when “Done” was changed to “Send to History.”
The ability to duplicate a worksheet will probably make this trivial, but currently it is fairly time consuming to set up the History worksheet with the correct columns and data types because copy/paste doesn’t copy the custom colors used for the Select data type. So, I’ll put in another plug for making a “Duplicate Sheet” feature available for copying worksheets.
Here is the automation that I used:
When setting up the automation, a window popped up that allowed me to map the columns to the correct columns in the History worksheet.
I like that I can ignore columns that don’t make sense to transfer to the History worksheet (by leaving the mapping blank). In general I really like the way the mapping works. I experimented with deleting a column from the History worksheet and the automation still worked. Then I could click on “Row” in the automation work flow to update the mapping again if I made changes to the columns. Very smooth.
Note: Formatting of cells (like font color, bold, size, etc) is not preserved when moving rows via automation. This is not a bug in my opinion, because there may be times when you don’t want the formatting to be copied/moved along with the row. However, you might consider adding an option within the automation for allowing formatting to be preserved (if people request that).