How can I copy rows in a workflow WITHOUT copying all the columns?

Alexa Jans

I have set up a workflow which goes like this: New Purchase Request ---> Ordering Database ---> Inventory. The rows are moved from the purchase request to the ordering database, then copies to the inventory smartsheets. There is information required in the purchase request that is not needed in the ordering database, and information in the ordering database that is not needed in the inventory sheets. How can I only coping the columns needed in the workflow?

Andrée Starå

Hi @Alexa Jans

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 use cross-sheet formulas and VLOOKUP or INDEX/MATCH to show the information needed for the specific process. 

Would that work/help?

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!