Locking Values in Row

I have a column on Sheet 1 that has a formula that references a value on Sheet 2. If the value on Sheet 2 changes,  obviously the cell in Sheet 1 updates automatically. 

I have another cell in Sheet 1 that is a dropdown. One value in the dropdown is "Completed".

The values in Sheet 2 may change once a year, as we adjust payment amounts for tasks.

Is there a way that once the dropdown cell in Sheet 1 is changed to "Completed" all of the values in the row are locked, meaning the value in any cell (that references cells in Sheet 2, are locked and are no longer updated, even if referenced cells in Sheet 2 change?

Thanks!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!