Send date from Excel to Smartsheet

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!

Best Answer