Formula to duplicate all rows in one column to another column in another sheet
Hello
i am looking for a formula that would allow me to duplicate all the rows in a column onto another sheet with the intention being that if additional rows are created/modified/deleted on the original sheet that the formula will automatically update the row data on the other sheet. Cell linking is not an option due to skill level of users. Any suggestions?
Answers
-
I would set up an automation to copy rows from Sheet 1 to Sheet 2 when they are added to Sheet 1. Thus, Sheet 2 will have all the rows Sheet 1 has.
Sheet 2 can use an INDEX(MATCH()) formula in the column of interest to take in the value of the same row in Sheet 1.
Though this begs the question why this strategy is being used as opposed to something like a report?
Dan Palenchar | School of Sheets Solutions Consulting (Smartsheet Aligned Gold Partner)
Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
Smartsheet Tutorial Videos: schoolofsheets.com/youtube
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!