Working with dynamic cumulative fractions

I am trying to create pareto charts for dashboards. I am referencing a sheet where I create totals and counts etc. One is a count of total items in a team. Impact =(Count@row / (SUM(CHILDREN(Count$2))) to get percentage for items for each team overall. Cumulative is for Pareto charts =SUMIFS(Impact$3:Impact$20, Row$3:Row$20, @cell <= Row@row). Row is a helper column that holds the row number. The problem is, when I sort the column Impact, The formula in Cumulative changes. So the absolute row numbers will not stay the same. For instance if I sort Impact in Descending the formula in Cumulative becomes =SUMIFS(Impact$17:Impact$3, Row$17:Row$3, @cell <= Row@row). Why are the absolute values changing? I update this sheet manually when the count changes and sort Impact column, but if the formula in Cumulative changes, the Pareto is all messed up.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!