Automated Copy / Move rows between sheets - just copy some columns


Dear all,

I'm a project manager and recently started using Smartsheet. I'm trying to configure an intake-prioritization and approval process for all the projects requested by our users.

I have my main sheet called it : Project Requested 2021

then I created another sheet for the projects approved by the Board: Project Approved 2021

and I'd like to move or copy some of the projects that were approved, but I don't want to transfer all the columns, just relevant information .

is it possible to do that ? automatically copy some rows but not all the columns in the row?

if it's not possible, what would you suggest to do ? Could you recommend some good practice to stablish this type of process ?

Thank you so much,

Ana Hernandez

Best Answer