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

  • David Tutwiler
    David Tutwiler Overachievers Alumni
    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: