Countif - Multiple outcomes?
Hi,
We run a design Dept sheet accessed by 5 sales reps who can select 1 Request Type from 10 set options that don't change (RT column) IE: Drawing OR Drawing and costs OR TSR OR Permit etc.. These I count easy enough rep x rep (countifs) with that data displayed on a dashboard. When a RT is assessed by the design team it is placed in to a Status (column drop down) which has 7 types that can change based on the progress of the task, IE: In progress - Not started - Revision - Pending etc.. again I count these per above.
I have been asked to show in a stacked bar chart on the dashboard counts against each RT and their status, issue is this can be different for the 1 RT type. IE: Drawing (RT) can have any 1 of the 7 status types, first day Drawing could be at In Progress, next day at revision.
Any suggestions on how to count.
Cheers Jason.
Cheers.
Answers
-
-
-
You should build a separate metrics sheet that organizes this data and build charts off of that. You can have your RTs going down the primary column and each status option going across (or vice versa). Use cross sheet COUNTIF formulas to get the data into what is basically now a data table. Use this data to create your bar chart.
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
@SoS | Dan Palenchar Cheers Dan, will have a look at that - I did start that but then thought there might be a formula to manage that, hard to imagine I'm the only one out there with this issue.
Cheers.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!