Report and Dashboard

Dina B

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.

kioshi43

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.

Dina B

@kioshi43 What is a roll up sheet?

kioshi43

https://community.smartsheet.com/discussion/comment/444994#Comment_444994

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.

Dina B

@kioshi43 Thank you. :)