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