Need a workaround to change the primary column of a sheet
I copied a sheet from another workspace into mine and its primary column does not match my others. There doesn't appear to be a way to change the primary column assignment after the fact, so I'm looking for a workaround solution.
Can I export/import and change the primary column that way? I have attachments and comments I worry about losing as a result.
Thanks
Answers
-
It is a pain when this happens but here is what I have done in the past:
- Create a new column next to primary column (Name it the same with (non primary) ex Column Name (non primary)
- Drag all the populated cells to this column
- If you already have a column in the Sheet that is what you want to be the primary rename it Column name (old), drag all the information from that column into the Primary Column and Change the name now to what it needs to be.
- Delete the Column Name (old)
- Rename the Column Name (non primary)
If you get stuck feel fee to email me at mkalinowski@genoahealthcare.com
MARLANA KALINOWSKI
Sr. Business Analysts / Smartsheet Solutions
National Pharmacy Services | Genoa Healthcare
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 138 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives