Data Automation with Different Column Headers
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!
Answers
-
Make the source and destination sheets have the same column arrangement.
...
-
That's right. The information in the columns is the same but the source sheet headers are in English and the destination sheet headers are in Arabic/English. I'm trying to figure out if there is a way to copy them over without having to manually move the data in the destination sheet.
-
@Alexandra Prescott Unfortunately Smartsheet needs it to be 1:1 for the copy. However there are a couple of options. You can use formulas to capture and collect data from sheet to sheet, or you can still use the copy row automation, and then on your new sheet use a column formula to make your new column equal to the copied column.
Then you could hide the copied row columns. The only thing I am not sure is if SS will unhide the columns automatically every time your automation executes.
