How to pull data from one sheet column to another sheet column

Valentine

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.

Monique Odom-Stearn

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:

https://help.smartsheet.com/functions

Valentine

https://community.smartsheet.com/discussion/comment/408699#Comment_408699

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.

Valentine

https://community.smartsheet.com/discussion/comment/408699#Comment_408699

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

Monique Odom-Stearn

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.

Valentine

https://community.smartsheet.com/discussion/comment/409064#Comment_409064

understood, thank you

Andrée Starå

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!