How to use INDEX function to copy a column from one sheet to another

Sean Smith7

Hello,

I'm trying to copy a column of dates from one smartsheet to a different smartsheet. I'll call the source sheet "A" and the copy to sheet "B". There are several columns in "A" and I just need to copy one column with dates into "B". Also, I would like the B sheet to update when a new row is added to sheet A. I've tried using the INDEX function without any success. I'm I heading down the right path or should I be using a different function.

TIA,

Sean

Victoria_Indimar

Hi @Sean Smith7 ! Do you need to have the dates stay "linked" and up-to-date in B if anyone changes the dates in A? Or do you just want a straight copy of them at the time they are entered?

Depending on what you have in A and B, you could do a combination of an Index/Match in B to pull the dates in A if you have a consistent and unique "key" to match against. For new rows, you can add an automation in A to copy all new rows into B so that key is added there and then the column formula in B will "take over" so any date changes in A will still be reflected in B. Does that make sense?