the best way to import excel sheet whit sub item
![charles1001](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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...
Answers
-
@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
-
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..