how many ongoing and done to show using a pie chart?

kumars23
kumars23 ✭✭
in Smartsheet Basics
open close.PNG

hello,

how many ongoing and done to show using a pie chart? please suggest ideas. I appreciate any help. Have a nice day

· Share on FacebookShare on Twitter

Answers

  • NickStaffordPM
    NickStaffordPM ✭✭✭✭✭

    Step 1: So you will make a metric within the Sheet Summary function on the sheet A3 Database. One metric will be a COUNTIF referencing the the ONGOING steps and one will be a COUNTIFS referening the DONE Steps

    Step 2: Then you create a Sheet Summary Report based on the A3 Database, pull in both of those metrics you created.

    Step 3: Create a dashboard, select Pie Chart and have the data be the Sheet Summary Row Report Referenced in Step 2

    If you found this comment useful, please let me know by clicking one of the buttons below: Awesome, Insightful, Upvote, or Accepted Answer. Your feedback will assist others looking for the same information and also help me out.

    Thanks!

    Nick Stafford

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video