Archived 2016 Posts

Archived 2016 Posts

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

edited 12/09/19 in Archived 2016 Posts

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.

 

 

 

 

2016-07-07 08_33_33-Hierarchy Sample - Excel.png

Comments

  • Employee
    edited 08/26/16

    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!

  • Employee
    edited 07/11/16

    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. 

     

This discussion has been closed.

Trending Posts