Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Data Automation with Different Column Headers

✭✭✭✭
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!

Answers

Trending in Smartsheet Basics

  • I have a dashboard that is using a Metrics Widget to display summary data. I want users to only see the summary data for their region. What is the best solution to achieve this? Is Dynamic View a solu…
    User: "Christopher S"
    Answered ✓
    17
    3
  • Hello! I am very new to smartsheet - lots to learn! I have a dashboard that has a metrics table at the top which is from a report. The report is a simple table which uses =SUM equations to get the yea…
    User: "Hester"
    Answered ✓
    19
    1
  • Hi Smartsheet Community, I was working on a dashboard and clicked the "wider canvas." When I was about to return it to its original view, the wide option was no longer available. Can you please help m…
    User: "OSE Helpdesk"
    Answered ✓
    23
    2