Change parent row from import

Ben Swaby

We are looking at switching from google sheets to smartsheet and cannot seem to find a way to change the parent row in smartsheets.  We have selected every option that we can find, but just not the right one. 

 

Note:  We want the parent row to be our task name, so that it shows up in the calendar view.  Currently it's a number, which makes the calendar view completely useless.

Mike Wilday

According to this article from SmartSheets you can select the article on the import from Google Sheets. https://help.smartsheet.com/articles/504645-primary-column?ss_lc=en_US

 

In light of that, you can also change the column... try adding a new column and copying the data from the number one into the new column, rename the original column to Task Name and copy the content into that column. That will become your new primary column. If you're using any web forms, make sure you update them accordingly. 

Mike Wilday

Just read their tip.. Which confirms what I just said. 

TIP: While you can’t designate another column as the Primary, you can insert a new column to your sheet, cut and paste the data in the cells from the exiting Primary Column to this newly inserted column, and paste the preferred data into the empty Primary Column.