Copy specific column from one sheet to another automatically.

rye
rye ✭✭✭
edited 04/09/24 in Formulas and Functions

Hi ,

I want to copy a specific column from one sheet to another sheet automatically.

e.g. I have sheet1 with column "Employee ID" . Now I want to copy "Employee ID" column from sheet1 to sheet2 "Employee ID" column.

I have used column formula as below: =INDEX({sheet1 Range 1}, MATCH([Employee ID]@row, {Employee ID}, 0))

I'm getting #CIRCULAR REFERENCE error . Could someone please help me how to copy specific column from sheet1 to sheet2.

Answers

  • Razetto
    Razetto ✭✭✭✭✭✭

    @rye Hi, the error is because the formula is referencing itself. For example, besides having the employee id in sheet 1 you also have the employee name listed, then your formula in sheet 2 should reference the employee name in order to pull the employee id from sheet 1. The reference can also be a unique unique so you could have a column that creates a auto number for each record; this number is what you'll reference in sheet 2 to bring the employee id

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!