Help with percentage of text columns
I am struggling with finding the formula to determine the percentage of locations in North America, that are currently active. My sheet has 100 rows with different territories (North America, Asia, Europe, etc) and I want to be able to determine the percentage of "currently active" locations in each territory. Any help is appreciated, I am brand new to smartsheets!
Thank you
Answers
-
First we need the count of how many total we have for "North America".
=COUNTIFS(Region:Region, "North America")
Next we need to find how many are "Active".
=COUNTIFS(Region:Region, "North America", [Current Status]:[Current Status], "Active")
Divide the second by the first, and you get the percentage as a decimal.
=COUNTIFS(Region:Region, "North America", [Current Status]:[Current Status], "Active") / COUNTIFS(Region:Region, "North America")
Format as a percentage and you should be set.
Help Article Resources
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
Check out the Formula Handbook template!