Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Change parent row from import

Ben Swaby
Ben Swaby ✭
edited 12/09/19 in Archived 2017 Posts

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.

Tags:
· Share on FacebookShare on Twitter

Comments

  • Mike Wilday
    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. 

    · Share on FacebookShare on Twitter
  • Mike Wilday
    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.

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories