Can someone assist with looking at children rows vs selecting exact cells?


Each time I change the sorting of this sheet, my formulas are changed. The formula is technically correct, the issue is that I am referencing exact cells, so when sorting it throws it off.

=SUMIF([Open By Year]38:[Open By Year]43, @cell < TODAY(), [Total Units Signed For]38:[Total Units Signed For]43) - [# Open]@row

I have attached a screenshot below:

Can someone please assist? TIA!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!