Create rows based on a Cell content
I'm trying to find a solution for the following example below:
Is there a way to create rows as many of values are recorded in a cell? in this example below you can see what I wanted to obtein. (The list of affected units is loaded from a separete form)
Even better would be to generate child rows
I try to avoid performing this task manually.
Thanks in advance for support
with best regards
Yosu
Answers
-
I cant think of a way to do this with out of Box functionality. If you own Pivot you could use that and then edit the resulting pivot sheet.
-
Thanks Mark,
Could you introduce me to this Box Functionality?
Regarding Pivot Table, I have already several created, I tried already but I do not see very clear how to use pivot table and be consistant in the process. And also need manual edition of the resulting table.
Thanks again for the answer Mark!
Regards
-
Out of Box just means standard functionality that comes with smartsheet. Do you own datamesh? Witha combination of datamesh and pivot you may be able to do what you need to do but I'd need to see the solution.
-
Thanks Mark,
I misundertands with BOX application.
I have not experience with Datamesh solution. Do you have some tips to follow?
Thanks in advance
Yosu
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!