Welcome!

Data Uploader

Hi,

I developed a data uploader workflow in order to update a sheet with the information that is exported from another sheet. The way that I understood this tool is: depending on the settings that I will do, the target sheet should be updated with the information from the attachment file in the source sheet so if the information in the target sheet is A but in the attachment it is now B, the workflow should read the attachment and perform the modification accordingly and add the new lines if there is any.

Currently I'm getting an error message that says: Add rows to target sheet: Value is not supported for this column type. Use objectValue instead and the lines where I did some modifications are not updated in the target sheet.

Does anybody have an idea on what can be wrong?

Regards,

Audrey

Find more posts tagged with

Comments

Anthony M.

Hi Audrey,

We may need to gather more information on your Data Uploader configuration and the data you are managing. From the error given, this may be related to a contact column and Data Uploader not currently supporting multi-contact columns. If this is the contact column type you are attempting to update, changing back to a single contact column type may resolve your issue. The inability to support multi-contact column types is something our developer team is aware of. However, I am unsure of any ETA of when/if this may be supported.

However, if you are not utilizing a multi-contact column, I would suggest opening a ticket with our Support team at https://help.smartsheet.com/contact to allow us to dive deeper into the behavior seen.

Kind Regards,

Anthony

Smartsheet Support

Audrey Larouche

Hi Anthony,

thank you for your response. Yes the sheet contains a contact column with multi-contact so it is probably the reason of my problem.

In the meantime one of my colleague showed me the DataMesh application which may be more useful for what I would like. Are you aware if there is a limitation about the system columns? I tried to develop a config that is using an auto-number column (Row ID) as lookup value and I also have an error message: Message: Error! Cells containing system values cannot be inserted or updated through the API, columnId : 7637558952781700. The config are attached. This was the only way that I can be sure to have unique information.

Regards,

Audrey

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet Button on Left of Sheet - Error Message
Could somone tell me what button this error message is referring to? I have an Enterprise plan and do not see anything like a "Sheet" button.
Access to a longer published sheet
Hi! I created a Calander events availability tracker and I attached it to a dashboard that I am creating in Smartsheet. It is now unable to display and a notification appears saying that, "The sheet you are attempting to access is no longer published. Please contact the Smartsheet document owner." I am wondering how to…
Cell Links Between Sheets Don't Work Consistently
Hi - I have set data mesh cell links between multiple SmartSheets that I own. The properties of the columns on the different sheets match. In the Data Mesh set up, I've selected: To overwrite content To create cell links To run immediately I have multiple instances where data changes on the source sheet and does not update…