Copy column from 1 sheet to another

I have 3 columns from sheet 1 I need to copy over to sheet 2. Date Absence Starts, Date Absence Ends, and Employee Name - Reason Code.

I have tried Index/Match and Vlookup, but I cannot figure out what I am missing to get my formula to work. After looking at some of the help discussions, I added a Row ID column to both sheets.

Both screen shots are of sheet 2, referencing the Row ID column and Date Absence Starts column of sheet 1.

Best Answer

Answers

  • Brian Wilson DC
    Brian Wilson DC ✭✭✭✭

    @Alicia L it is because you are missing some information in your formula. I setup the following two sheets below. I have my source sheet which I made look like this:

    And my destination sheet. The destination sheet I will show you in sections so you can see the INDEX/MATCH formula I used to gather the information. I renamed the ranges so they tell you exactly what column I used them to pull from on my original sheet.


    For the date columns, make sure you set the column to a "date" column type, but you will need to un-toggle the "dates only" option so you can use a formula there to capture the date you want to import. Otherwise, it will flag you with an error.

    I hope this helps!

  • Alicia L
    Alicia L
    Answer ✓

    Thank you! This solved my issue.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!