How to address column restriction error and value does not conform to req for PICKLIST?

jshrum · 10/31/23

Within Data Shuttle, 4 days ago I started having Data Shuttle workflows that would not work. I am trying to upload data from an excel sheet that is housed in one of my other Smartsheets. The workflow error states "Unable to update row in target sheet : CELL_VALUE_FAILS_VALIDATION: The value for cell in column 9950538889 did not conform to the strict requirements for type PICKLIST." I have restarted all Smartsheets, tried remapping the workflows, and I can't get it to work. This error is happening on other Data Shuttle workflows/different sheets also. I also have an additional error on other sheets that states "Failed to insert 1 row because the columns in the target sheet are restricted. Please review your column settings." How do you determine which column is 9950538889? What is a PICKLIST? I also have no idea what made columns restricted. How do you make them unrestricted? I am not using any APIs, just Data Shuttle uploads/downloads to move data around numerous sheets. Thanks for any help you can give.

jshrum · 11/01/23

Not sure why Smartsheets all of a sudden had issues, but the problems were associated with date and drop down columns being restricted to dates only, and only drop down items. Had to turn all of them off. Seems to be working so far.

Mark Lappegaard · 11/01/23

Same thing happened to me. Followed jghrum's solution and it worked. Have not looked to ensure the dates (within Smartsheet from Data Shuttle) are now consistently "dates" vs. "text".

David_S · 11/02/23

Same thing is happening to me, but it is a normal text field with restriction on the dropdown values, which are all text. I checked the sheet and they are all valid values that would be on the dropdown options.

I had to disable all column value restrictions as well.

Can someone from Smartsheet confirm if this is a bug and if so, when can this be resolved?

Paul M Kahl · 11/02/23

As others have stated, this validation issue showed up unexpectedly this week (for me with one workflow on 10/30 and another on 10/31).

Restricting to dates is the preferred setting for the affected columns, so it would be helpful to understand if the root cause is a bug or a feature enhancement.

Genevieve P. · 11/03/23

Hi all,

Thank you for posting your concerns and for those of you who opened support tickets. I checked in with Support and based on the reports you sent they were able to identify that this is indeed a bug and our engineering team is working on a resolution ASAP.

I'll post again here once a fix has been implemented.

Thanks,

Genevieve

Genevieve P. · 11/03/23

Hi @jshrum, @Mark Lappegaard, @Paul M Kahl, @David_S

A fix has been implemented and you should no longer see this error in Data Shuttle. Thanks again for your patience and for reporting this to our Support team!

Cheers,

Genevieve

jshrum · 11/03/23

Thanks for the help and quick action.

Mark Lappegaard · 11/06/23

Very nice to see this community process in action, starting with @jshrum posting the issue. Was reassuring not to waste a lot of my time thinking the problem was internal. Thanks to @Genevieve P. and the rest for the fast fix.

MWilkesen · 06/17/24

Genevieve P.

Nov 3, 2023

Hi @jshrum, @Mark Lappegaard, @Paul M Kahl, @David_S
A fix has been implemented and you should no longer see this error in Data Shuttle. Thanks again for your patience and for reporting this to our Support team!
Cheers,
Genevieve

@Genevieve P.

I am seeing that this error seems to have reoccurred! Is the Smartsheet team aware already?

Thanks.

Michael

Genevieve P. · 06/18/24

Hi @MWilkesen

A few questions here:

Is this happening on all workflows, or on one specific workflow?

If it's just one workflow:

Is this a new set-up, or a previously working set-up that has suddenly changed?
Were there any changes made to the destination sheet column that could have impacted your flow?
Does it happen when you re-create the workflow?

If none of this helps, then yes, please report it to the Support team with the responses to the questions above, as well as a full screen recording showing your flow set-up, source data and destination sheet (providing them with the sheet URL, too).

Cheers,
Genevieve

Carla PMwow · 08/27/24

Hi @Genevieve P. I am also having the same issue with new data shuttle workflows. Is there a fix for this? it is frustrating. Thanks

Screenshot 2024-08-27 184739.jpg

Uploaded Aug 27, 202428.46 KB

Genevieve P. · 08/27/24

Hi @Carla PMwow

That looks to be a slightly different error, and one that's expected if your columns are restricted in the sheet you're updating. Can you double check the columns that you're updating to see if you have the Restricted box checked?

API & Developers

API & Developers

How to address column restriction error and value does not conform to req for PICKLIST?

Answers

Quick Links

Categories

Trending in API & Developers

Intermittant Smartsheet Login Issues Using Power Automate

PHP integration for Smart sheet.

How can I use API to attach a local PDF to a Smartsheet row through Kofax/Tungsten?