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 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

Updating a the wrong row in Samrtsheet

  • February 25, 2020
  • 7 replies
  • 381 views
J

Hello,

I have a zap that triggers when a new row is added in Smartsheet, it then uses a column in smartsheet to lookup data in Google sheet then return that data to update the rest of the row in Smartsheet.

The issue is when the data is returned to Smartsheet it is being updated in Row 3 instead of the row tht it should update which is row 1. The new rows in Smartsheet are always added to row one.

In creating the Zap it shows I am selecting it to return the data to row 1. Not sure what I am doing wrong. Can anyone help??


Thank you,

joe


Best answer by Joe

Thank you all for the advice.


I ended up making a work around. The trigger is still when a new row is added on Sheet A. The zap then takes a column and does a look up on google sheet and grabs all the other info I need. But instead of returning it to the same sheet to update the Original Row (which was giving me the issue), I created a new sheet Sheet B and chose the Zap to Add a New Row, which I have all of the info populate into that sheet.

A little more messy, but it seems to work. Does make me nervous having to maintain 2 sheets, but in theory it should work fine.


Thanks again for all the help,

Joe


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

7 replies

AndrewJDavison
Forum|alt.badge.img+11
  • AndrewJDavisonZapier Solution Partner
  • Zapier Solution Partner
  • February 25, 2020

Hi @Joe

Can you show us a screenshot of how you have the update row step setup.


Find out more and hire me: https://zapier.com/partnerdirectory/andrewjdavison (andrew@andrewjdavison.com)
J
  • Joe
  • Author
  • February 25, 2020

Here is where it returns the data back into Smartsheet. And all of the data is correct, just wrong row.

image.pngNow when I hit that drop down to select a row, there are row ID's attached to the row number, and I am not sure if that is an issue, because I do not want to update that row ID persay, I always want to update whatever row was added.

image.png


AndrewJDavison
Forum|alt.badge.img+11
  • AndrewJDavisonZapier Solution Partner
  • Zapier Solution Partner
  • February 25, 2020

Hi @Joe

In that Row ID dropdown, scroll to the bottom and select "Use custom value" - the in the new field that appears, map in the 'Row ID' from the prior Smartsheet step and it will then update the correct row.


Find out more and hire me: https://zapier.com/partnerdirectory/andrewjdavison (andrew@andrewjdavison.com)
    J
    • Joe
    • Author
    • February 25, 2020

    Thanks for the quick reply. I just did what you said and added the ROW ID of the previous Sartsheet step. And when the Zap ran it updated the row that I entered. Which ended up being the 7th row down.


    Is there a way I can say return it to the same row that triggered the Zap? I feel like when I type in a specific row it will always update that specific row.


    AndrewJDavison
    Forum|alt.badge.img+11
    • AndrewJDavisonZapier Solution Partner
    • Zapier Solution Partner
    • February 25, 2020

    The thing is - each row has a specific ID, as and you mentioned, new rows get added at the top - and when they do, they get assigned a unique ID.

    The zap isn't going to be able to know what the ID for that row is - and as you've discovered, you can't just select the row number - you have to input the row ID.

    I'll open this up to others who might have better ideas. @Danvers perhaps?


    Find out more and hire me: https://zapier.com/partnerdirectory/andrewjdavison (andrew@andrewjdavison.com)
      jesse
      Forum|alt.badge.img+9
      • jesseArchitect
      • Architect
      • February 26, 2020

      @Joe, @AndrewJDavison_Luhhu is correct in that you would have to know the Row ID and be getting that from another step to be able to dynamically select the row for the action as there is no "Find Row" Search Action for Smartsheet at the moment.

      That being said, if Smartsheet is your Trigger, so long as the data from that step includes a Row ID, you can map that into Step 3 using the "custom value" option and that should allow you to update the same row that triggered the Zap.

      Let us know if that's helpful!


        J
        • Joe
        • Author
        • Answer
        • February 26, 2020

        Thank you all for the advice.


        I ended up making a work around. The trigger is still when a new row is added on Sheet A. The zap then takes a column and does a look up on google sheet and grabs all the other info I need. But instead of returning it to the same sheet to update the Original Row (which was giving me the issue), I created a new sheet Sheet B and chose the Zap to Add a New Row, which I have all of the info populate into that sheet.

        A little more messy, but it seems to work. Does make me nervous having to maintain 2 sheets, but in theory it should work fine.


        Thanks again for all the help,

        Joe


          Terms & ConditionsAccessibility statement