Does anyone know away around the lack of an “action” step with Smartsheet to be able to identify a row? It seems like a very basic function. I can use a workaround of creating a google sheet with the identical information as Smartsheet, but seems redundant and a greater chance of error.
Best answer by nicksimardView original
I just wanted to make sure that I understand what you’re looking for. Are you asking about a search action for Smartsheet, like a Find Row? If not, can you please elaborate a bit on what you’re seeking? Thanks!
That is correct, I am looking for Find Row. I think I came up with a clunky workaround of entering all the information into a Google Sheet including the Smartsheet Row ID, then using the Google Sheet to Find a Row in my secondary zap, which I then can use to find the Smartsheet Row and update. But I’d love to cut out Google Sheets in this process.
Thanks for confirming! Glad you found a workaround in the meantime, but I’m sorry to say that the last time we checked, the Smartsheet API didn’t support a Find Row search action.
It's something other users have asked for so I've gone ahead and added your vote for this feature request. Should this bubble to the top, we'll be sure to let you know.
Smartsheet owns and updates that integration so it may be worth it to reach out to them and let them know you'd like to have that feature added :)
They do have access to the feature requests in our system but it always helps if they hear directly from their users as well.
If you can add one more person to this request and vote, please do. In fact, I am a little upset that I needed to build the same kludgy solution using a google sheet that Ross did above and now get charged a task because this is not possible.
@meanmna I’ve added you as a vote for that feature request!
+1 here, please add my vote.
Please add me too! Hope to have this function soon!
Please add me - I would like to Find Row based on Primary ID column
please add me
@juliap, I’ve just added your vote to the feature request!
I am requesting this feature as well. Thank you.
@llmu92, I’ve just added your vote to that feature request as well.
We’ll be in touch with any updates on that!
Please add my vote also, seems to be a fundamental piece of function!
I’ve added your vote to the list :) As of a month ago, we heard from Smartsheet and they say that there are some limitations on their end that prevent this action from being implemented in an efficient manner. If you’re looking for more details, your best bet would be to reach out to their Support team. You could mention to them how important this functionality is to you, and maybe they have a feature request list they can add you to.
For all of those on this post that responded to my original question. I was tired of waiting for Smartsheet to develop a better Zapier integration. So my team and I developed a much better zapier integration. Our Zapier app allows you to do not only row lookup, but also select an attachment from a row for use in a zap, update multi-select fields, add an image to a cell, move a sheet to another folder and more. If you’re interested in testing it out, you can sign up here https://thirddegreeleverage.com/smartsheet/ and we will invite you. I will put together a video soon on how to use each of the features. I hope it helps the Zapier/Smartsheet community!