Update the value of a contact
I am using the Smartsheet Python library, but this could also apply to the API. I am having trouble updating the Assigned To column, which I see is actually a column type of contact list. I have tried specifying a cell value and I get an error message saying "'Value is not supported for this column type. Use objectValue instead.'" When I set the object value to a Contact object, I get the message ""Required object attribute(s) are missing from your request: cell.value.""
The API does not allow setting both the object_value and the value.
If anyone has successfully updated the contact/assignee for a row or has suggestions, please help!
Answers
-
Hi @Y79jH
Is this a multi-select contact column or single select? I found this related Community Post that may help you: Updating rows with multi_contact cell?
-
@Y79jH I did the below workaround using API python. The Contact List was just too complex and not flexible for me to work with.
Column A is my picklist and column B is a cross-sheet reference to the directory to capture email. As new records are registered in the sheet directly or via a form, I have automation in place to send update emails as specific information is updated or nearing a deadline.
First, I get the Column ID info.
import smartsheet
smartsheet_client = smartsheet.Smartsheet('INSERT TOKEN')
action = smartsheet_client.Sheets.get_columns(SHEET ID, )
columns = action.data
for col in columns:
print(col.title)
print(col.id)Then, I update Column A to a picklist with options.
import smartsheet
smartsheet_client = smartsheet.Smartsheet('INSERT TOKEN')
column_spec = smartsheet.models.Column({
'type': 'PICKLIST',
'Options': [
"INSERT NAME 1",
"INSERT NAME 2",
"INSERT NAME 3",
"INSERT NAME #"
]
})
response = smartsheet_client.Sheets.update_column( SHEETID, COLUMNID, column_spec)
updated_column = response.result
So far, I have not hit a ceiling as my records < 1K.Erin Horiuchi Green, MBA, LSSYB, PSMI
Process Manager
Syneos Health
Please kindly like ❤️, upvote ⬆️ and/or mark ✅ any of my contributions that have provided value.
Core App and Project Managment Certified 🚀
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives