Copy all Data from one Column in a sheet to another column

Hi ,

I'm trying to copy all the information from one Column to another Column in a different smartsheet.

Can I use Index for this? I see example of index/match but I don't have anything to match.


Example

Sheet name "Testing" Has several columns one of which is named "ITEMS"

Sheet name "Testing 1" Has several Columns one of which is name "LIST"

I want whatever is in sheet "Testing" column "ITEMS" row "1" to appear in

Sheet "Testing 1" column "LIST" row "1" and then turn it into a Column formula so it will work all the way down.


Bonus if the formula shows blanks instead of some other error message, if the Cell in the source column is empty.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You shouldn't need a unique identifier on the source sheet if you are wanting to pull everything over exactly as is.


    On the second sheet you can use a text/number column (called "Number" in this example) and manually enter the numbers 1 through however many you need. I suggest also including some extra space as a buffer.


    Then you can use this as a column formula:

    =IFERROR(INDEX({Column To Pull Over}, Number@row), "")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!