Automation Copy row
I have two sheets with the same column names. On sheet one, one of the properties of the column is a dropdown (Single select). On sheet two, the column with the same name has its properties set to Text/Number. If the column properties are different, will it still copy over the data that is in that cell?
Best Answer
-
It will copy over the data, but it may create a new column on the far right of the sheet to match the column type. I am not sure. Have you tested it yet?
Answers
-
It will copy over the data, but it may create a new column on the far right of the sheet to match the column type. I am not sure. Have you tested it yet?
-
@Paul Newcome Sorry, I should have just tested out before asking the question. It does only pull over the row's data, and it does not make a new row. Thank you
-
No worries. Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!