Data Automation with Different Column Headers

Alexandra Prescott
Alexandra Prescott ✭✭✭✭
edited 02/19/24 in Smartsheet Basics

Is there a way to copy a row from one sheet to another with different column headings? I'm trying to copy data from a general invoice tracking sheet to a country-specific invoice tracking sheet with Arabic column headers. The automation I have currently set copies the data to columns at the end of the new sheet and we have to manually move it to the correct columns.

The purpose of copying the data to a country specific sheet is to be able to download the data with Arabic column headers to a CSV file from Dynamic View.

Any insight or workarounds would be great. Thanks!