Advice for Primary Column
What would you recommend I use as a Primary Column on this sheet? Here are my columns and their type:
- School Name: Drop Down
- Month: Drop Down
- School Year: Drop Down
- Total Volunteer Hours: Number/Text
- Submitter: Contact List
- Comments: Number/Text
Most of the columns are Drop Down or Contact Lists which can not be Primary Columns.
The two Number/Text columns do not seem to be useful for the Primary Column
In fact, I am not sure I see the value of a Primary Column in this sheet. We will not be using the Primary Columns hierarchy features for this collected data.
The data will be collected on a monthly basis.
Comments
-
If you don't need the Hierarchy, you can leave it blank.
I'd be tempted to reproduce the [School Name] column
=[School Name]@row
It would depend on what sort of Reports you are building.
Craig
-
Another option would be to "Hide" the column. You could also click/drag to move it in to order of where you already need a text/number column.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Yep, what Paul said. If you aren't using Reports, just pick any Text/Number column to be the Primary.
Craig
-
Thanks that helps clarify the role of the Primary column. It is really all about hierarchy. If the sheet data doesn't have such a structure, I can ignore it
-
That's pretty much it. You can still use hierarchies even without populating the Primary Column as well. The primary column is where your expand and collapse buttons are housed. The only restrictions are that it will always be a text/number type, and it cannot be deleted.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Unfortunately, the Primary Column cannot be hidden from card view so ignoring it from the grid view will show as "untitled" in card view, which is disappointing. Are there other suggestions for a primary column value in OP example?
-
@cbukowski You can use a cell reference to replicate whatever you are using to determine the lane.
=[Column Name]@row
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thats helpful - thanks @Paul Newcome!
-
@cbukowski Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 286 Events
- 33 Webinars
- 7.3K Forum Archives