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.

Locked is greyed out in pull-down menu

Andrew Buck
Andrew Buck ✭
edited 12/09/19 in Archived 2016 Posts

I have a spreadsheet that was shared with me.  I made a copyu of it so now I am the owner.  I would like to make it into a template, but prefer to lock the formula columns.  However, even if I stand on my head, I can't get the the locking feature to become available.

 

Thanks!

Andy

· Share on FacebookShare on Twitter

Comments

  • Travis
    Travis Employee

    A few questions for you:

     

    You own the sheet and are unable to lock a column?

    What type of column are you trying to lock?

    Just to confirm, this is a sheet and not a report, correct? A report will have a "Report Builder" tab at the bottom.

     

    Could you post a screenshot of what you see when you right click on the column header?

    · Share on FacebookShare on Twitter
  • Andrew Buck
    Andrew Buck ✭

    Hi Travis,

     

    Yes, I own the Sheet.  It has a Text/Number column type. There is no "Report Builder" tab at the bottom.

     

    Here is the screen shot.

     

    Mmmmm.  Wait! It ain't greyed out anymore!  But it was, it was!!  Man you are really good Travis.  :)

    lock.JPG

    · Share on FacebookShare on Twitter
  • Travis
    Travis Employee

    Good to hear, Andrew! 

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

Categories