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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!