About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

Smartsheet - match unique column IDs to update fields?

  • 5 January 2021
  • 1 reply
  • 454 views
G

Hello - I am new to Zapier and can’t am unclear if the Zap I hope to build is possible. I have done a few hours of reading, and don’t see any mention of what I need to do. It seems so basic, I feel I must have missed something. Any help is most welcomed!

 

End goal -- make 1 Smartsheet sheet that updates only select column fields from Excel data leaving the rest of the column fields untouched by the Zap. I want to Zap to find corresponding Project ID’s then update select fields.

 

How I envision the workflow: 

  1. When new rows are created in our single Excel sheet it triggers the Zap
  2. The Zap searches the single Smartsheet for matching Project ID fields. 
  3. When matching Project ID’s are found fill only selected Smartsheet cells with Excel data.
  4. Remaining Smartsheet cells remain untouched by the Zap (meaning 4 out of 10 columns will be updated but the rest stay as untouched)

To put it another way:

FIND: Smartsheet column 1 “ID #1” = Excel column 1 “ID #1”

REPLACE: Smartsheet Columns 2-5 with data from Excel Columns 2-5 using the ID’s

DO NOT REPLACE: Smartsheet Columns 6-10 

 

Work around ideas - if it isn’t possible to go from excel to Smartsheet could I accomplish Smartsheet to Smartsheet? Smartsheet to Excel? 

Just trying to find any way to update ONLY select columns based on a shared Row ID # between 2 spreadsheets.

Thank you very much for reading this post! I look forward to hearing your input!

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

nicksimard
Userlevel 7
Badge +11

Hi @GwenM!

Because Smartsheet’s integration does not have a Find Row search action, that means that you’ll need the Row ID to be in the trigger step (you mentioned Excel). 

Not sure if your data is set up in such a way that you can do that. If so, you would have a column in the Excel spreadsheet then you’d map that here:

That’s the Row ID field in the New Row Update action for Smartsheet.

Then you would only map Excel values (from your trigger step) to the Smartsheet columns you want to update (in your action step). The ones you leave empty should remain untouched and will retain the original data that was there before you updated it.

Hope that helps point you in the right direction.

Terms & Conditions