Setting date in Project profile data from Master intake form

Ezra

Am I missing something? I've been trying to push the start date of a project from the intake sheet (via intake form date input field) without success. 

Upon spinning up the project in SCC, I get the error:

• Failed to update template field(s) for "Project Profile Data" (Code: 5536 - Message: The value "04-27-2018" could not be saved in column "Start Date". This column is restricted to ABSTRACT_DATETIME values only. )

Which, to me, says that the date field from the form is not sending the correct format of date to the Project profile data sheet. The regional (default format) is "04/27/18" as opposed to 04-27-2018

There might be some work-around for this by separating the schedule information and gantt from the profile data.. however this would introduce other problems (like pushing an updated date to the overall summary sheet whenever someone changes a task date in a project). Also, I really don't want to make it a two-three step process just to submit a project that should begin or end on a certain date. 

TLDR: Setting date in form. Using Control Center to make project. Date not being injected correctly. Any pointers? 

Alejandra

Hi Ezra,

ABSTRACT_DATETIME is a project date value in ISO-8601 format: 2019-07-01

If needed, more information on this can be found here: https://smartsheet-platform.github.io/api-docs/#cell-reference

Ezra

Thanks, Alejandra.. however I'm not writing an API addon, just trying to take a date entered by a Smartsheet user in a Smartsheet form as a project "start" date. But every time I think I have it, Smartsheet complains about the format. I've even tried pulling it apart and reformatting the ISO8601 format (YYYY-MM-DDTHH:MM:SSZ) to read as MM/DD/YY - but that doesn't work either.