JAVA SDK - Update a Multi Picklist

david.kershaw

Hello,

I am having trouble updating the value of a multi-picklist in my sheet. I am using the Java SDK smartsheet-sdk-java 3.1.1, on Java 17. I am setting the column value with the following code:

Cell c = new Cell(column.getId());

c.setObjectValue(new MultiPicklistObjectValue(List.of("All", "Some", "None")));

My column I am updating looks like:

{

"title": "Programming",

"type": "MULTI_PICKLIST",

"options": [

"All",

"Some",

"None"]

}

All my other columns update fine, but I can't figure out how to use this SDK to update a Multi Picklist. Any help is much appreciated!

Genevieve P.

Hi @david.kershaw

Here are some conversations I found on StackOverflow that may help:

https://stackoverflow.com/questions/66079478/arbitrary-http-api-call-to-enter-cell-value-into-a-mutl-picklist-column/66080043#66080043

https://stackoverflow.com/questions/27124753/updating-cells-in-smartsheet-java/27136236#27136236

I don't personally work with the JAVA SDK so I'm unsure what the exact syntax would be, but if you're looking to update a cell with multiple values, I believe you'd need to identify the "objectValue" to have the "objectType" as "MULTI_PICKLIST" and then list the "values" afterwards.

Here's the Java SDK on GitHub and the API Documentation around updating rows.

Cheers,

Genevieve