Is it possible to only copy certain cells with automation?
We have a Master Task Order list which contains a multitude of data for a single project. At different stages of the process, parts of this data are copied to multiple other sheets.
Is it possible to set up an automated workflow that would copy only specified parts of this data when criteria is met? I.e. select which columns of data are included in the row copy function.
Ex: The Task Order #, Name & Date that the Task is Requested will be copied to Sheet 1 when the Date the Task is Requested is entered. Other Project ID #, Name & Value from the same row are copied to Sheet 2 when Date the Task is Received is entered.
Help Article Resources
Check out the Formula Handbook template!