Control Center Summary Rollup and use of Primary Column
This one has got me stumped. In our original Summary Rollup Sheet that was setup by Smartsheet staff, we have our Project Number defined as the primary column which is nice and neat for the variety of reports we generate from it:
But when I created a secondary Summary Sheet, the Primary Column became some sort of concatenation of Project Number - Project Name, and even some of the projects don't have data in this column:
This makes for awkward reports where we must include the Primary Column, but it doesn't have good data so we have to hide it all the time. This complicates the use of Grouping in reports since it seems you can't use Grouping if the Primary Column is hidden.
Does anyone know if there is a trick to setting up a new Summary Sheet and defining what the Primary Column will be? Thanks in advance for any advice!!