Data Shuttle Upload error: column formula not supported. Columnid:

Options
Jeana
Jeana ✭✭✭✭✭✭
edited 06/14/22 in Add Ons and Integrations

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.

Thanks!!

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    Hi @Jeana

    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:

    Cheers,

    Genevieve

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    Hi @Jeana

    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:

    Cheers,

    Genevieve

  • dled
    dled ✭✭
    Options

    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.