Best answer

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

  • 28 March 2020
  • 1 reply
  • 35 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

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!

 

View original

This topic has been closed for comments

1 reply

Userlevel 7
Badge +10

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!