Row Count by Department
On my sheet, I have a Department column that is filled in on every row. There are about 1200 rows total. Some example departments are: Accounting, AP, AR, Benefits, etc.
In addition, every row has a Status, Start Date, and End Date column filled out too.
I have a dashboard for this sheet. I would like to add a bar chart that shows Remaining Tasks (i.e., rows) by Department. Meaning, any tasks that where Status <> 'Complete'.
I thought about adding summary formulas to the main sheet, but that seems tedious, especially if departments are added or changed later. I also tried creating a report, but couldn't figure out how to count by department in a summarized way to report on the dashboard.
What is the best way to accomplish what I'm trying to do?