So I keep getting this error and I've checked the mapping of my data and can't see anything obvious.
The error is
It refers to a columnid but I don't know where to find that in my file to figure out what the problem is.
This error indicates that one of the columns you've mapped in your first screen capture contains a column formula. Data Shuttle cannot write to this column and it should not be mapped in the workflow.
Can you check your destination sheet to see if any of the columns you have listed in the workflow have the small fx in their column title? This will be the one that's causing the error:
My sheet had a bug of some sort because the column throwing the error was supposed to be coming from Smartsheet to Jira (which should be supported), not being synced from Jira to Smartsheet.
However, I figured out how to answer the question originally asked which was "How do I find out which column the columnId is referring to?"
I don't have access to the API so that answer on another thread did not work for me.
However, using Firefox, I navigated to the Fields Mapping page, right clicked and chose "Inspect". This brings up the html code... At the top of that page, I simply searched for the columnId sent in the alert.
It took me right to the appropriate area and under the arrow, I found the column's name.
I have created a Data Shuttle upload, with no filters, to replace rows on my Smartsheet destination sheet. I discovered that all rows were not being added to the destination sheet. Debugging narrowed the problem down to the contents of one column. In Smartsheet, the column is formatted as Text/Number. In Excel for testing,…
We are considering upgrading to Advance, and I have questions about Bridge capabilities: Our project blueprint includes multiple reports that pull entries from master logs based on the job number. This means that our admins have to add the job number to every single new report filter when they set up a project. Can Bridge…
Hi, Can dynamic views be accessed on smartphones/mobile devices? I don't see this option on the app.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.