Send date from Excel to Smartsheet

Roy Yue

Hi, I found a way to send cell value from Excel to Smartsheet, however the date cell value always has error when sending to Smartsheet.

The CRD column is Cargo Ready Date, which is set as Date property.

In my Excel, I also have CRD date entered as date format.

When I send Excel row to Smartsheet, it says "{"response": {"statusCode": 400, "reason": "Bad Request", "content": {"detail": {"index": 0}, "errorCode": 1012, "message": "Required object attribute(s) are missing from your request: cell.value.", "refId": "e4xqzk1c1u1i"}}}"

I think the date format creates issue when sending date to Smartsheet.

Thank you!

Genevieve P.

Hi Roy,

A list of all the 400 error codes can be found in our API docs (click here). You're receiving 400 / 1012, "A required object attribute is missing from your request: {0}." It's saying that you haven't got the right cell.value specified for that part of the request.

Are you using the "Add Row" request? (See here) If so, are you specifying that the column type for your CRD column (after the column ID in the request) is a Date type?

The Smartsheet API returns all dates and times in the UTC time zone in ISO-8601 format, that is, YYYY-MM-DDTHH:MM:SSZ. Try adjusting your dates in the Excel to be this format and see if it will recognize the data then.

https://smartsheet-platform.github.io/api-docs/?python#dates-and-times

Genevieve P.

Hi Roy,

A list of all the 400 error codes can be found in our API docs (click here). You're receiving 400 / 1012, "A required object attribute is missing from your request: {0}." It's saying that you haven't got the right cell.value specified for that part of the request.

Are you using the "Add Row" request? (See here) If so, are you specifying that the column type for your CRD column (after the column ID in the request) is a Date type?

The Smartsheet API returns all dates and times in the UTC time zone in ISO-8601 format, that is, YYYY-MM-DDTHH:MM:SSZ. Try adjusting your dates in the Excel to be this format and see if it will recognize the data then.

https://smartsheet-platform.github.io/api-docs/?python#dates-and-times

Roy Yue

Thanks again genius.

Genevieve P.

Hahaha any time!

Laura Carruthers

I had the same issue, except was using Workato to automatically update a Smartsheet using Google Sheets data. I changed the google sheet format to YYYY-MM-DD and it pulled it in correctly.