row sorting is juggling formula

We have created a sum function in a row that has been copied down for 100 rows.  We are only reading data from each row......not holding a cell from a previous row.  When sorting and filtering throughout the day, we are finding that the sum functions are trying to read previously held row designations.  Row 10 may read the sum of row 20, and so on.  We have tried using the $symbol to hold the row, and we have tried not using the $symbol. 


How should this formula be built to follow the row when being sorted or moved up and down in a sheet?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!