Sorting and conserving formula


When I sort rows, the formulas are not maintained:

= SUMIF($[column_A]$7:$[column_A]237, "Received", [Column_B]$7:[Column_B]237))

gets transformed into this:

= SUMIF($[column_A]$57:$[column_A]237, "Received", [Column_B]$57:[Column_B]237))

the $ has no effect.

and I cannot use the [column_A]:[column_A] syntax as it will return me circular error due to my calculation above rows 7.


I am looking for the possibility to SUMIF everything under row 7 regardless the sorting.


Any suggestion?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!