Insert data from another sheet - Copy
Can you please provide a formula where I can copy data from one sheet to another using formula.
No vlookup is required.
This is a simple copy of the data from one sheet's column to another sheet's column.
Answers
-
Hi! Is there a 'Condition' or 'Criteria' to trigger this need to copy? I've always done these with an Automation workflow, see attached .pdf (Copy Row is at the very bottom). If there is no condition you can have it do so automatically at a scheduled time interval.
- Seth
-
Hi Seth,
Thanks for the reply.
This copies all the columns from a row, but I need only one column from the row not all.
Example:
In Sheet 1, there are Employee ID, Employee Name, Address, Salary columns. Whenever this row gets added in Sheet 1, we need to add Employee ID in Sheet 2.
Could you please provide me steps to handle this case.
Regards,
Shwetha
Help Article Resources
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
Check out the Formula Handbook template!