piechart
![kumars23](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
hello,
how many ongoing and done to show using a pie chart? I need to make the ongoing and done status in one column. please suggest the formulas
please suggest ideas. I appreciate any help. Have a nice day
Best Answer
-
Hi Kumar
I am not sure which formula you need, so here are some options:
1) To create a table like Ariel's from your Ongoing Status and Close Status columns you can use a COUNTIF formula
=COUNTIF([Ongoing Status]:[Ongoing Status], "ONGOING")
=COUNTIF([Close Status]:[Close Status], "DONE")
2) To combine your Ongoing Status and Close Status columns into one column you can use an IF formula with a second, nested IF formula to be evaluated if the first is false:
=IF([Ongoing Status]@row = "ONGOING", "ONGOING", IF([Close Status]@row = "DONE", "DONE"))
I hope one of these is what you need.
Answers
-
Hi Kumar,
There will be a need for you to create a new sheet where your pie chart will reference data from. You'll need this sheet to count how many On goings and Done's are in that tracker in your screenshot. the outcome will look like from my screenshot on the left hand side. then your pie chart should look like what i got. Hope this helps!
-
hi Ariel,
can you please send the formula?Thanks
-
Hi Kumar
I am not sure which formula you need, so here are some options:
1) To create a table like Ariel's from your Ongoing Status and Close Status columns you can use a COUNTIF formula
=COUNTIF([Ongoing Status]:[Ongoing Status], "ONGOING")
=COUNTIF([Close Status]:[Close Status], "DONE")
2) To combine your Ongoing Status and Close Status columns into one column you can use an IF formula with a second, nested IF formula to be evaluated if the first is false:
=IF([Ongoing Status]@row = "ONGOING", "ONGOING", IF([Close Status]@row = "DONE", "DONE"))
I hope one of these is what you need.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives