the best way to import excel sheet whit sub item

charles1001

is it possible to import an excel which is already divided with the sub-elements so as not to work twice? I don't want to go through all the lines to adjust them by hand when my dynamic crosstab already does it...

Lucas Rayala

@charles1001 - unfortunately, no, you can't do that. great suggestion! I suggest you submit to the Product Ideas page:

https://community.smartsheet.com/categories/smartsheet-product-feedback-&-ideas?sort=top

charles1001

Damn!!

For my part, the only solution I found is to add a column with simply the numbers so I want a delimitation.

1 for the main ones, 2 for the subtitles, 3 for the task itself and so on...

Once imported into smartsheet, I filter by removing the number 1 and I move all the elements to the right.

Then I uncheck #2 and move all the lines to the right and so on...

This way I can quickly arrange everything quickly as I want in smartsheet..