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

How to find a row in middle of rows in Smartsheet?

  • November 1, 2019
  • 7 replies
  • 345 views
Vera
Forum|alt.badge.img
  • VeraZapier Expert
  • Zapier Expert
  • 6 replies

Hi guys,

does anyone know a way how to find a row in a middle of rows in Smartsheet?

I need to find and insert data into this report when I don't know the ID. Zapier only allows to add a row to the buttom and top or by ID. I need to look up the right "general requirements", find the right subcontractor name and paste to the buttom my data.

Screenshot 2019-11-01 15.31.09.png



Best answer by Danvers

Hi @Vera! Thanks for the great question 🙂

We do have a feature request open for this addition to the SmartSheets Zapier integration and we're in the process of working with SmartSheets to see if it will be possible to add this. I've added you to the feature request, which means that we'll drop you an email if it does become a reality.

In the meantime, it looks like you have some great workarounds above!


View original
- Vera | Connex.Digital
Did this topic help you find an answer to your question?
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

ikbelkirasan
Forum|alt.badge.img+12
  • ikbelkirasanZapier Expert
  • Zapier Expert
  • 555 replies
  • November 1, 2019

Just looked at the current Smartsheet app and it doesn't seem to provide any search steps. The Smartsheet API does support searching through sheets though. https://smartsheet-platform.github.io/api-docs/?javascript#search-sheet

So, it looks like you need to develop a custom Zapier app that provides search capability then you will be able to retrieve the row ID from the search results.


Ikbel | Building custom Zapier Apps | Want to build a custom Zapier app for an API? Visit our website: https://norapps.com Or email us at info@norapps.net
Vera
1 person likes this
  • Vera
    Vera
PaulKortman
Forum|alt.badge.img+10
  • PaulKortmanZapier Expert
  • Zapier Expert
  • 469 replies
  • November 1, 2019

Yes its possible with a custom Zapier App, but you might be able to do it with a simple webhook: https://smartsheet-platform.github.io/api-docs/?javascript#authentication-and-access-tokens suggests that you don't need the full oauth 2.0 workflow for the authentication, thus a simple webhook could get the information you need.


Need Additional help? Feel free to reach out here: https://zapier.com/experts/connex-digital/
ikbelkirasan
1 person likes this
  • ikbelkirasan
    ikbelkirasan
Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • Answer
  • November 4, 2019

Hi @Vera! Thanks for the great question 🙂

We do have a feature request open for this addition to the SmartSheets Zapier integration and we're in the process of working with SmartSheets to see if it will be possible to add this. I've added you to the feature request, which means that we'll drop you an email if it does become a reality.

In the meantime, it looks like you have some great workarounds above!


E
1 person likes this
  • E
    EJones
Vera
Forum|alt.badge.img
  • VeraZapier Expert
  • Author
  • Zapier Expert
  • 6 replies
  • November 4, 2019

@Danvers Awesome and thanks for adding me into the future request.



- Vera | Connex.Digital
E
  • EJones
  • 1 reply
  • February 19, 2020

@Danvers If we'd like to follow along on this feature request, is there a way for us to view it or follow for any updates?


steph.n
Forum|alt.badge.img+8
  • steph.nBuilder
  • Builder
  • 899 replies
  • February 20, 2020

@EJones Hello, and yes. You my submit your feature request by sending us an email to contact@zapier.com with details about the feature request you are looking to receive updates about. We will add your request to our wish list and inform you when there's new updates.

Thanks!


SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 7906 replies
  • February 7, 2024

Hey folks,

Just wanted to share that it’s now possible to search for an existing row using a query with the Smartsheet app on Zapier! 🎉
35c5877f95dfab33cc5e6935f498d616.png
 

Please note: This action was added using a beta feature known as Custom Actions, which you can see referenced in the name of the action.


Please do give that new “Find sheet Row” search action a try and let us know if you run into any issues with it. In the meantime, happy Zapping! ⚡

Terms & Conditions