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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!