Is there a solution available to copy an entire column from one sheet to another automatically
I have a sheet that updates everyday adding names, tasks, booked manhours and more columns. The sheet over a period of 25 days (max period) will populate with over 2000 rows. I would like to copy the booked manhours (Time) column everyday into another sheet. I do not want to copy the information in the other rows.
I am aware of the workflow automation function however this will copy/move all information in each row. Is there a way to create a workflow that will only copy/move selected column into another sheet?
I have tried to copy and paste link values into the other sheet however Smartsheet only allows a max of 500 rows at a time? With the sheet updating each day (Deleting and refreshing with new data) this will become to tedious a task.
I hope this makes sense! Thank you for any help.