Copy all Data from one Column in a sheet to another column
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.
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.
Help Article Resources
Check out the Formula Handbook template!