Error due to contact column format in DataTable. Code:1018

lschek1
lschek1 ✭✭
edited 06/13/24 in Add Ons and Integrations

I have a workflow that consist of offloading data from some grids to attachment, then attachment to DataTable (via DataShuttle) and finally from DataTable to a new Smartsheet grid connected.

The issue I found is that it can't add new data due to an error in a contact column. This is the error message:

Error ocurred. Code: 1018. The value 'name <email>' was not valid for the parameter 'contact.email'.

Tags:
· Share on FacebookShare on Twitter

Best Answer

  • Brian_Richardson
    Brian_Richardson Overachievers Alumni
    Answer ✓

    If your data is in there as Brian Richardson <brian.richardson@ironmountain.com> then it's not going to work. Needs to be an email address only for the contact column to recognize the data when it comes in.

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN

    · Share on FacebookShare on Twitter

Answers

  • Brian_Richardson
    Brian_Richardson Overachievers Alumni
    Answer ✓

    If your data is in there as Brian Richardson <brian.richardson@ironmountain.com> then it's not going to work. Needs to be an email address only for the contact column to recognize the data when it comes in.

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video