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

Yes, but you'll need criteria to the formula so it knows what it should reference.
Make sense?
Would that work/help?
✅Remember! 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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers

If possible, I’d recommend making the formula a column formula, and then it won't break.
Would that work/help?
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Hello,
Can I make it a column formula if each cell within that column may contain different references?
For Example:
Row 1 may be referencing Maria's timesheet
Row 2 may be referencing Bridget's timesheet
Row 3 may be referencing Maria's, Bridget's, and Logan's timesheet

Yes, but you'll need criteria to the formula so it knows what it should reference.
Make sense?
Would that work/help?
✅Remember! 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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!