10,000ft Bulk CSV Upload - dates not importing
Hi,
I'm new to 10,000ft so I may be missing something.
When trying a bulk upload with a .csv file, the start / end dates do not import into 10,000ft. I have tried several different formats, but it still remains blank in 10,000ft.
When I manually enter in the dates in the use profiles and export, they show up just fine.
I have a few hundred resources I need to enter, so the bulk upload is really the way I want to go.
Thanks for any help or direction you can provide,
Chris
Best Answers
-
Hello @Christ0pher Smith ,
If you are importing users, please ensure your Date Format is YYYY-MM-DD, if importing projects, then please ensure your Date Format is MM-DD-YYYY.
See more on this here: https://help.smartsheet.com/articles/2481973-column-inputs-and-formatting, https://help.smartsheet.com/articles/2481126-import-multiple-projects
If this doesn't resolve your issue, please reach out to Smartsheet Support here: https://www.smartsheet.com/contact, and provide as much information as possible E.G A copy of your file, steps taken to produce error.
Kindest Regards
Sean
-
Thank you Sean. I had just gotten the same answer back from Smartsheet support the day before your posting but I wanted to say thanks, and to close the loop in case anyone else is searching for this.
Obviously as you open the exported .csv file Excel is "super helpful" by changing the formats for you, so it wasn't 100% clear that the formats had changed and needed to be changed back. And of course I missed this additional link off the "bulk import" instruction page.
Thanks again for taking the time to provide an answer, it is much appreciated,
Chris
Answers
-
Hello @Christ0pher Smith ,
If you are importing users, please ensure your Date Format is YYYY-MM-DD, if importing projects, then please ensure your Date Format is MM-DD-YYYY.
See more on this here: https://help.smartsheet.com/articles/2481973-column-inputs-and-formatting, https://help.smartsheet.com/articles/2481126-import-multiple-projects
If this doesn't resolve your issue, please reach out to Smartsheet Support here: https://www.smartsheet.com/contact, and provide as much information as possible E.G A copy of your file, steps taken to produce error.
Kindest Regards
Sean
-
Thank you Sean. I had just gotten the same answer back from Smartsheet support the day before your posting but I wanted to say thanks, and to close the loop in case anyone else is searching for this.
Obviously as you open the exported .csv file Excel is "super helpful" by changing the formats for you, so it wasn't 100% clear that the formats had changed and needed to be changed back. And of course I missed this additional link off the "bulk import" instruction page.
Thanks again for taking the time to provide an answer, it is much appreciated,
Chris
-
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending Posts
- I want to use Power Automate to send a professionally formatted email with Smartsheet data embedded in it. For example, Power Automate would receive the person's name, email, and pre-filled form's lin…
- Hello! Happy Friday! 😀 I am currently working on creating a Supply Request Tracker that will allow the requestor to upload their excel file with the list of needed supplies to a Smartsheet form conne…
- I setup a new Smartsheet and am connecting it to Jira Cloud. All fields are syncing properly except the Team field. I have the column set up as text number but have also tried it as a Drop Down list. …
