Feature request Automation: using an automation rule to move or copy only some data, not entire rows

Tom Bentz

Can automation function to MOVE or COPY data based upon some conditional change allow a use to select what fields get MOVED or COPIED and map to a specific column name? On my first SmartSheet, I might have 20 columns, when a status changes and an automation rule is triggered, I only want 5 of those field to be copied or moved to another sheet and placed in specific rows and order. Column names could be the same, but I dont ned or want all of the original data in the second sheet. The second sheet could have many more columns than the first one. Data would be mapped by selecting which columns to copy and would be delivered to columns of the same name in the new sheet.

Andrée Starå

Hi @Tom Bentz

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could either hide the columns that you don't need or use a cross-sheet formula to only show the columns needed in another sheet.

Would that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!