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.

We are running into problems in creating our zap. We are using Smartsheet and zapier rather than using smart sheet’s Shuttle feature.

When a new job is entered to the "job master" sheet, we want to update the dropdown selections of the job number on the "Load Master" sheet so that it reflects all Jobs from the "Job Master" sheet, including the newly entered job. 

On Zapier, when we have the steps so far set as:


Step 1: Trigger event is a new row in the job master sheet

Step 2: Export the “Job #” column

Step 3: step 3 is a “Run Python” option. This is where we begin running into issues. We put “jobNumbers” for the input data, and specify the “Job #” column for the column, but zapier shows the column as “No Data”. We have verified that correct permissions are set, the field is not a hidden field, it is named correctly, and it definitely does have data.

Step 4: we use the “API Request (Beta)” to pull from a variable created from the previous step. But since no data is being pulled from step 3 since the Job # column is showing “No Data”… we are running into errors. Why isn’t data being pulled from this smartsheet column?!

Please help!

Hi and welcome to the Community ​@Blackgoldgroup 👋 Sorry no one’s replied here sooner! 

Not sure if you’ve already got this sorted - if you have, we’d love to hear what the solution was 🙏

If it’s not solved, how is the information added to the row is another Zap adding it, or is it added manually? Just wondering if it might be that the Zap is triggering before the Job # is manually added to the row? That might explain why the Zap is showing that column as containing no data.

In which case it might be worth switching to use the Updated Row trigger instead and add a “Send to Zapier?” column to the sheet with a checkbox (that is ticked after all the necessary details are added). Then use a Filter in the Zap to only allow the Zap to continue if that checkbox is has been ticked.

Do you think that could work?

Terms & ConditionsAccessibility statement