10K FT - did the Project Import function change?

MCorbin

Am I losing my marbles, or did the 10K FT project import function change today? It went from a copy/paste to export a CSV and import the same format.

Since it appears to be adding the ability to import our custom fields, I'm thrilled, except I'm getting a date format error - it's telling me I have invalid dates, but I can't find any documentation on the change, let alone what the date format should be (I'm using the same format I did previously - mm/dd/yyyy)

Anyone have some insights?

MCorbin

I'm going to answer my own question....

Yes, the functionality changed.

No, they didn't announce it.

And no, yesterday the help page hadn't been updated, but it has been updated today.

The date fields need to now be formatted as yyyy-mm-dd, which (hooray) is an option in Smartsheet date formatting.

BUT.... The data needs to be in a CSV format, which we can't export directly from Smartsheet (boo!)

Enhancement request has been submitted to make the update accept a format that I can export from a Smartsheet intake sheet (if it's bugging you, please submit your own request too!)

https://app.smartsheet.com/b/form?EQBCT=739aa75f30ca43a8a22eb53e4da7d409&_ga=2.37989219.1109569095.1515413508-505700647.1490279283

MCorbin

I'm going to answer my own question....

Yes, the functionality changed.

No, they didn't announce it.

And no, yesterday the help page hadn't been updated, but it has been updated today.

The date fields need to now be formatted as yyyy-mm-dd, which (hooray) is an option in Smartsheet date formatting.

BUT.... The data needs to be in a CSV format, which we can't export directly from Smartsheet (boo!)

Enhancement request has been submitted to make the update accept a format that I can export from a Smartsheet intake sheet (if it's bugging you, please submit your own request too!)

https://app.smartsheet.com/b/form?EQBCT=739aa75f30ca43a8a22eb53e4da7d409&_ga=2.37989219.1109569095.1515413508-505700647.1490279283