How do Lock cells like L$2 in excel and rows $l2 or $l$2, is possible to do in Smartsheet

Karan Buga

Mike Wilday

You can lock rows and columns by right-clicking on the column header OR row number. You can also lock a row using automation,

based on conditional events that occur in the sheet.

You can't however lock a single cell.

I hope that helps!

Paul Newcome

If you are referring to an absolute reference to lock in a cell/row/column within a formula, it is exactly the same.

Column:

$[Column Name]2

Row:

[Column name]$2

Cell (column and row):

$[Column Name]$2

Mike Wilday

🤦‍♂️ Uh. yeah, What he said! 👆️

Paul Newcome

Mike Wilday

Seriously. I think I just need to slow down and read.

Paul Newcome

@Mike Wilday Haha. I do the same thing sometimes too.