Copy Rows Automation - Only certain columns?

Copy Rows Automation - Only certain columns?

GordonGordon
edited 06/29/20 in Using Smartsheet

When a copy row automation is triggered, is there a way to only copy certain columns/cells in that row?

If not, is there a way to then take the output sheet data and cross reference to matching rows in a third sheet, and can I build further automations off of the destination sheet?

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Gordon,

    Unfortunately, it's not possible at the moment to select which columns to include (it's coming), but it's an excellent idea!

    Please submit an Enhancement Request when you have a moment

    As a possible workaround, you could, as you mention, use cross-sheet formulas, but you'll need to have some unique identifier.

    Would that work?

    I hope that helps!

    Be safe and have a fantastic week!

    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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  •  (it's coming), 

    Sooner the better

Sign In or Register to comment.