Copy to another sheet not working
Hi, my goal was to copy from excel to a sheet, but that is not working for me, so I decided to try the copy to another sheet automation. I would like to import new data from excel into a sheet and have it copy to another sheet. I have also tested manually adding data, but it's not work. Can anyone tell me why it's not working? Thank you
This is my automation
Best Answer
-
The copy to another sheet automation is specific to another sheet within Smartsheet itself. To do what you have described would require Data Shuttle premium app (or manually doing an export or import), but this cannot run on a schedule. Depending what which plan you have, you may already have this option. Data Shuttle allows you to not only import data from an outside sheet (Excel or Google sheets) but you can export data from Smartsheet back out to an Excel or Google sheet and it can be set to run on a schedule. It can also be used to populate dropdown columns in Smartsheet. Here is a link that may help describe what Data Shuttle can do ... https://www.smartsheet.com/marketplace/premium-apps/data-shuttle, this link may help too https://help.smartsheet.com/learning-track/integrations-and-add-ons/data-shuttle
Smartsheet Overachievers Alumni
Answers
-
The copy to another sheet automation is specific to another sheet within Smartsheet itself. To do what you have described would require Data Shuttle premium app (or manually doing an export or import), but this cannot run on a schedule. Depending what which plan you have, you may already have this option. Data Shuttle allows you to not only import data from an outside sheet (Excel or Google sheets) but you can export data from Smartsheet back out to an Excel or Google sheet and it can be set to run on a schedule. It can also be used to populate dropdown columns in Smartsheet. Here is a link that may help describe what Data Shuttle can do ... https://www.smartsheet.com/marketplace/premium-apps/data-shuttle, this link may help too https://help.smartsheet.com/learning-track/integrations-and-add-ons/data-shuttle
Smartsheet Overachievers Alumni
-
Thank you for the answer. I finally got copy and paste to a sheet working, so I can add my rows that way.
-
So glad you found a workaround that is helping you with your solution. I find myself developing workarounds all the time, especially when we don't have the funding to pay for all the extras outside of the Core Product. I hope you are having a great day.
Smartsheet Overachievers Alumni
-
I found out how to paste from excel. I have to select all the need cells in columns and rows to get it to work. I had to start the selection of cells at the far right and last cell needing selected, then move left and up with my selections, so it stays selected when I paste.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives