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

Options
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

Comments

  • Travis
    Travis Employee
    Options

    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?

  • Andrew Buck
    Options

    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

  • Travis
    Travis Employee
    Options

    Good to hear, Andrew! 

This discussion has been closed.