Percentage based on "Complete"
Hello! I have a column labeled "Line Status" with many different statuses. One status is "complete" and I would like to produce a percentage based on the # of times complete exists compared to the number of lines with any status at all. Each line is a step in our process, and as we mark each line complete I would like it to show what percentage of all lines are complete - Thank you for any help!
Answers
-
I would do something like this:
=countif([Line Status]:[Line Status],"Complete") / countif([Line Status]:[Line Status],<>"")
Basically counting all completes and dividing it by all non-blank cells in the column.
-
Excellent! That worked very well - could I add another step? We would like "Ready to ship", "shipped", and "Complete" combined to represent % of project complete divided by total cells with any value in them - ?
-
I think I figured it out - does this look right?
=(COUNTIFS([Line Status]:[Line Status], "Ready To ship") + COUNTIFS([Line Status]:[Line Status], "Complete") + COUNTIFS([Line Status]:[Line Status], "Shipped")) / COUNTIF([Line Status]:[Line Status], <>"")
-
Hey @Cory Larsen
Just jumping in here to say that looks great! Well-done 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!