Copy some columns from rows to another sheet

System

This discussion was created from comments split from: Can one form link to two sheets?.

knguyen2

https://community.smartsheet.com/discussion/comment/347534#Comment_347534

Hi Andrée,

Is it a way to use workflows to copy just some cells in rows to another sheet?

For example I make the mastersheet having all columns for two forms then using form to log queries. For each query logged, I want to copy (8) columns to sheet A and the remaining columns to sheet B. Do you think of any workaround?

Thank you for your support.

Darren Mullen

@knguyen2 A couple options off hand:

1. If you have access to Smartsheet DataMesh, you can use that.
2. You can use an add-on like SmartLink:

https://youtu.be/0yWYR5klloE?si=uiYN3vsgAID1OvjY