How to freeze cell reference while copying a formula to the other cell.

Mindfull

Is there any way that I can ensure that at the time of copying the formula the cell reference doesn't change?

Thanks

Prajna

Andrée Starå

Hi Prajna,

Yes, you’ll use Absolute Reference for that to work.

More info.

https://help.smartsheet.com/articles/2476816-create-cell-column-reference-formula

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Ella

Thanks for the above link Andree! It was just what I was looking for.

Andrée Starå

@Ella

Excellent!

Glad to hear that it was useful for you as well.