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

Unable to write data to multiselect dropdown fields in Smartsheet

  • 6 October 2022
  • 2 replies
  • 261 views
P

I’m using Zapier to write data to a Smartsheet in response to a webhook.  Works fine except if one of the fields is a Dropdown field in Smartsheet with “Allow multiple values” set to True. 

The error received when testing the Zap is “Value is not supported for this column type. Use objectValue instead”.  I think this means that the Smartsheet API requires multiselect field values to come in as an object not a string, but Zapier is sending everything as strings. 

Has anyone else encountered this?  Below is an example of the field that throws an error when Zapier tries writing to it. 

 

2 replies

Todd Harper
Userlevel 6
Badge +8

In Zapier, when you are setting up your Smartsheet action, is there a dropdown displaying each of those occupations with a grayed out string of numbers and letters, as seen below?

If so, you’ll want to either add a code step or use a Lookup Table (in Formatter by Zapier utilities) to map the string from your webhook (ie, “Artist”) to the corresponding object ID (ie. “6148f88b2fd73cd680f9fec9” in my screenshot).

christina.d
Userlevel 7
Badge +9

Heya @PixelAzul! I wanted to swing by and see how you’re doing with this? 🙂
@Todd Harper has some real pro tips that hopefully helped get you back on track. Either way, let us know! We’d love to help.

Reply


Terms & Conditions