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,…
This formula is producing syntax error when I try to make the column a "column formula". Is there a workaround? As we add new Rows (copied from different sheet), I want all values in Client Name column to equal Task column Row 1.