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..
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives