Form entry data - need to copy and link certain cells to other sheet
Good afternoon! I'm trying to create a workflow to support an approval and review process for recruiting. I created a sheet with a form, and some of the form data needs to automatically feed into another sheet based on certain criteria met. I set a workflow to copy to another sheet based on that which works fine. My issue is that in each row, there are additional columns that will have action items in the main sheet that need to link to the other sheet as well so that team is notified when they have an action item. When I add the links, the new form entries go into a new line below the linked cells instead, where the links aren't set. Is there any way to automate this without having to link cells manually every time I need to make an update? We have a few different teams that will all need various data from the original sheet, so I need this workflow for a few groups, but haven't made it past the first one because of this hiccup.