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 nicksimard
You’ll be happy to hear that you can add a formula directly into the Zap editor. So whatever formula you’ve been using in the spreadsheet itself could be added into the action step of your Zap. Without knowing the exact formula you’ve been using, it’s hard for me to test it out and give you a screenshot. Can you give it a try and if you get stuck, can you tell me more about the data coming into your columns and what the formula is?