Sign in to join the conversation:
How would I go about trying to create a formula that scan down a column finding and grouping the same "assigned to" and then grabing that specific %cost and totaling them up in another cell?
You can use SUM with COLLECT like this:
=SUM(COLLECT([% of Cost]9:[% of Cost]34, [Assigned To]9:[Assigned To]34, ="Cement Guy"))
" =SUMIFS( " works the same way as " =SUM(COLLECT( "
Just another option to keep in mind.
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
