the best way to import excel sheet whit sub item
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
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives