Formula cross referencing sheet via template
I have a workflow created using Zapier so that when a new row is added to my master project sheet via a form entry it will update the first row in a template sheet and create a new project sheet from that sample sheet. This all works great with the exception I have one formula that uses a vlookup to tell the status of that project from my master project sheet - the formula comes up correct but as an external error message come up.
Is there a way to keep cross references live when creating copies of sheets??