Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Locking Formula ???


Hi Team,

I find my formulas change when i filter etc.

e.g. =SUM([Value Of Jobs]2:[Value Of Jobs]85)

       =SUM([Value Of Jobs]18:[Value Of Jobs]85)

My top row which i use to calculate columns keeps changing. How to I fix or lock formulas please. 


This discussion has been closed.