Updating a the wrong row in Samrtsheet

Hi @Joe

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

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

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

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.

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.

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?

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