I have a google sheet that receives responses from a google form.
One column on that sheet is the unique reference number (URN) which is generated from other cells in the row generated by each response (i.e. first 2 characters of column 1 plus last 3 characters of column 4, etc).
Currently, I need to manually copy and paste the formula into that column for every new row generated.
Is there a way for me to automate this using Zapier?
Thanks a lot!
Best answer by nicksimardView original