Is there a way to merge cells like Excel or 'roll up' data?
I'm trying to merge cells in 'Overall Program Status' column based on the 'Program' column. The 'Overall Program Status' is set at the Program level, so it's the same for each sub-program. The Sub-Program status is set at the sub-program level so it varies. Is there a way to roll up the Overall Program Status column so it's visually more appealing, and the symbols aren't repeated for each sub-program? I'm hoping for something along the lines of the 2nd image.
Best Answer
-
I think it might make more sense for you to restructure your rows. If you make the Overall Program to be the PARENT row and the subprograms to be CHILD rows underneath the PARENT row, it could solve all the problems you have and keep from duplicating things. Doing it like this would also allow you to write formulas for the PARENT row that would automatically change depending on the status of the CHILD rows.
Here is what it could look like as a screenshot below:
Answers
-
Does anyone know if you can merge cells in a sheet?
-
I think it might make more sense for you to restructure your rows. If you make the Overall Program to be the PARENT row and the subprograms to be CHILD rows underneath the PARENT row, it could solve all the problems you have and keep from duplicating things. Doing it like this would also allow you to write formulas for the PARENT row that would automatically change depending on the status of the CHILD rows.
Here is what it could look like as a screenshot below:
-
Thank you David.
-
No problem.
-
Thank you.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives