Report and Dashboard
In my sheet, I have a column calculating the NETDAYS between two events. This column does not show up if I try to create a Summary Report. It only allows me to create a Row Report. In a dashboard, how can I use a half-pie graph to show the number NETDAYS greater than 37 and NETDAYS less than or equal to 37. I do have conditional formatting in my sheet to show this, but I would like a half-pie graph on a dashboard showing these numbers. Thank you in advance.
Answers
-
What I would probably do in this scenario is create a roll up sheet where you could use a COUNTIFS formula to count the number of events that have netdays over 37 and the netdays equal or less than 37.
Once you have that, you could then create a row report with that roll up and slap it into a Dashboard as a pie chart.
-
@kioshi43 What is a roll up sheet?
-
A separate sheet where you can throw you can reference your original sheet in formulas. It helps out a bit in my work flow because I'll add in something like =Countif([reference source sheet], "Completed") to do a count of how many items in my source sheet have been done.
-
@kioshi43 Thank you. :)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
