Unlock specific cells

Hi SS community,

I am trying to unlock a specific cell in a sheet. The column needs to be locked because it is a "Start Date" column, but the one row needs to be manually inputted. Can I lock the entire column, but unlock the row or something? Please help me figure out a solution to this. Thanks!


  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭


    You can't unlock a single cell in a locked column. To do what you want, I suggest using an unlocked helper column to collect that manual input, and in the locked column's cell where you need that input, use a formula to reference that specific helper column cell (such as =HelperColumn1 or =HelperColumn$1).


    Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!