Locking a Sum Formula

Hello -

I am wanting to lock a sum formula and am not sure exactly how. Do I need to add additional aspects to the formula beside the "$"? The issue is people are moving items around in their timesheets which adjusts the below formulas and I want to make sure if they do this, the formula will not change.

Below are the two types of formula I am trying to lock.

=SUM({Chandra Time Tracker Range 3})

=SUM({Bridget's Timekeeping Range 2} + {Maria's Timesheet Range 3} + {Chandra Time Tracker Range 17})


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!