Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Asked & Answered Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Create a new row in Google Sheet and add 1 to a cell from the previous row's value in cell

LukaBazooka

Hey guys,

I’m hoping to get help from people more experienced than me. 

 

What I’m trying to achieve with my Zap in a simplified step by step:

1. Someone submits a Google Form

2. Add data from the form to a new row in the Sheet

3. Update the request number +1 to the previous request number

 

I don’t know how to get the request number from the already existing last row at the moment of creating a new row. I can’t look up the spreadsheet because I don’t have any value that I can input because none of them are known in advance.

 

Request # Date of request Full name Email Sample column
1 6/30/2021 18:46:38 Sample Name sample@email.com  
2 6/30/2021 22:25:28 Sample Name 2 sample@email.com  
3 6/30/2021 22:32:48 Sample Name 3

sample@email.com

  

 

The number in Column 1 would need to go +1 every time a new row is created. Should I use a formula for that? I’m not familiar with them though. 

Sorry if there is an answer for this already but I really tried to look for it and wasn’t able to.  

Best answer by GetUWired

@LukaBazooka 

I did some more digging and did find a formula for you to use! You can use the Index() formula to reference columns by location. So if Request # is in Column A you could use the following formula in your zap. 
=Index(A:A,Row()-1,1)+1
 

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.

4 replies

GetUWired
Forum|alt.badge.img+12
  • GetUWiredZapier Solution Partner
  • Zapier Solution Partner
  • July 9, 2021

Hi @LukaBazooka 

Assuming the request # will always be 1 less than the newly created row. When you create the row you could put in the formula =Row()-1 which would give the value of the row created minus 1

if the above won’t work, you could add a column to act as a look up column that always has a static value in it once a row is created. Then you can look up the last row. There are a few discussions on this: 

​​​​​​

    LukaBazooka

    Thanks @GetUWired !

    Both of them suggestions were my fallback solutions if nothing else would work or there wouldn’t be other solutions. 

     

    GetUWired
    Forum|alt.badge.img+12
    • GetUWiredZapier Solution Partner
    • Zapier Solution Partner
    • Answer
    • July 12, 2021

    @LukaBazooka 

    I did some more digging and did find a formula for you to use! You can use the Index() formula to reference columns by location. So if Request # is in Column A you could use the following formula in your zap. 
    =Index(A:A,Row()-1,1)+1
     

      LukaBazooka

      @LukaBazooka 

      I did some more digging and did find a formula for you to use! You can use the Index() formula to reference columns by location. So if Request # is in Column A you could use the following formula in your zap. 
      =Index(A:A,Row()-1,1)+1
       

      This is it! Thank you very much 🙏✌👍

        Early access


        Next Gen Zaps

        Build and deploy automations from AI tools you already use. With Agentic Management, if anything breaks, the agent diagnoses the issue and proposes a fix.

        Request access now


        Terms & ConditionsAccessibility statement