How to pull data from one sheet column to another sheet column
I need a formula that will extract all data from the column A in sheet A and auto fill it in column B in sheet B when added in the source sheet. Sheet A will have different columns and info than in sheet B, needed only the auto pulling of the data from this one column.
Answers
-
Hello @Valentine,
My suggestion would be to use an INDEX(MATCH()) or INDEX(COLLECT()) formula, and then make it a column formula. You can find information on the INDEX, MATCH, and COLLECT functions here:
If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!
Monique Odom-Stearn
Business Process Excellence Manager
Smartsheet Leader & Community Champion
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle
-
actually it's not what i meant, im already using formulas like index match index collect and same, but they all need a reference key cell, so i would like to know if there is a possibility to extract the data from one column of sheet A and insert it in to another column in sheet B, and the formula to not be based on anything else than the copyed cell from sheet A, kind of self dependent column.
-
i started using formulas not so long ago so probably i still dont understand how its fully working, if its possible can you please explain if i said something wrong in last message cause i read enough info on the forum and everybody is looking for hard constructed formulas but this basic one that im looking for is not required by anyone
-
Hello @Valentine, unfortunately I don't think this is possible without a reference column/cell. You can pull information in a single column over to another sheet with formulas or datamesh, but both require a reference column/cell to work.
If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!
Monique Odom-Stearn
Business Process Excellence Manager
Smartsheet Leader & Community Champion
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle
-
understood, thank you
-
Hi @Valentine
I hope you're well and safe!
You could use INDEX and only add a helper column for the row number that should be collected.
Something like this.
=INDEX({Cross-Sheet Reference}, Row@row)
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!