Insert data from another sheet - Copy

Can you please provide a formula where I can copy data from one sheet to another using formula.

No vlookup is required.

This is a simple copy of the data from one sheet's column to another sheet's column.


  • Seth Morth
    Seth Morth ✭✭✭✭✭

    Hi! Is there a 'Condition' or 'Criteria' to trigger this need to copy? I've always done these with an Automation workflow, see attached .pdf (Copy Row is at the very bottom). If there is no condition you can have it do so automatically at a scheduled time interval.

    • Seth

  • Hi Seth,

    Thanks for the reply.

    This copies all the columns from a row, but I need only one column from the row not all.


    In Sheet 1, there are Employee ID, Employee Name, Address, Salary columns. Whenever this row gets added in Sheet 1, we need to add Employee ID in Sheet 2.

    Could you please provide me steps to handle this case.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!