Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Hierarchy from Excel
Hi all, I have an Excel sheet that I export from TFS and has a hierarchy defined. I would like to copy it into Smartsheet and maintain that hierarchy without having to manually recreate it. Can this be done? I am not opposed to using Excel to reformat appropriately. I am just trying to avoid recreating the hierarchy every time we update the data.
A sample of the hierarchy in the export is in the screenshot below.
Comments
-
Hi Nick-- Great question! We don't currently support importing this kind of hierarchy from Excel--at this point there isn't a way for Smartsheet to translate the hierarchy you have set up as content in a column into the hierarchy format used in Smartsheet. Hope this clears things up!
-
Kennedy is correct that Smartsheet doesn't currently support creating hierarchy directly from sheet data, but if the Excel worksheet has an outline/group, it will attempt convert that into Smartsheet row hierarchy during import.
Excel outline/grouping is very similar to Smartsheet's row hierarchy with the ability to collaps/expand the heirarchy.
Hope this helps.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives