Best answer

How can I fill in a cell within a new row on Google Sheets?

  • 28 March 2020
  • 1 reply
  • 101 views

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!

icon

Best answer by nicksimard 6 April 2020, 20:51

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +11

Hi there!

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?

Thanks!