Copy specific column from one sheet to another automatically.
Hi ,
I want to copy a specific column from one sheet to another sheet automatically.
e.g. I have sheet1 with column "Employee ID" . Now I want to copy "Employee ID" column from sheet1 to sheet2 "Employee ID" column.
I have used column formula as below: =INDEX({sheet1 Range 1}, MATCH([Employee ID]@row, {Employee ID}, 0))
I'm getting #CIRCULAR REFERENCE error . Could someone please help me how to copy specific column from sheet1 to sheet2.
Answers
-
@rye Hi, the error is because the formula is referencing itself. For example, besides having the employee id in sheet 1 you also have the employee name listed, then your formula in sheet 2 should reference the employee name in order to pull the employee id from sheet 1. The reference can also be a unique unique so you could have a column that creates a auto number for each record; this number is what you'll reference in sheet 2 to bring the employee id
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!