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

Karan Buga · 05/16/22

Mike Wilday · 05/16/22

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 · 05/16/22

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 · 05/16/22

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

Paul Newcome · 05/17/22

Mike Wilday · 05/17/22

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

Paul Newcome · 05/17/22

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

Answers