Calculating Percentage in "Administrative Column")
Good day Smarters,
Any help would be appreciated.
I have three columns
- Status Column with Symbols: RED, Green and Yellow
- Category of Staff column which is a drop down, one of which is Administrative Staff among others
- Administrative Staff Column (fixed) to indicate my calculation(%) below
Question: How do I create a formula to reflect the % of Administrative Staff which are Green and Yellow? i.e (Green + Yellow)/ (Green + Yellow + Red).
Thanks in advance
Best Answer
-
You would use a COUNTIFS to get the count of green and yellow then divide it by another COUNTIFS that counts all rows. It would look something like the below:
=COUNTIFS(Category:Category, @cell = "Administrative Staff", Status:Status, OR(@cell = "Green", @cell = "Yellow")) / COUNTIFS(Category:Category, @cell = "Administrative Staff")
Answers
-
You would use a COUNTIFS to get the count of green and yellow then divide it by another COUNTIFS that counts all rows. It would look something like the below:
=COUNTIFS(Category:Category, @cell = "Administrative Staff", Status:Status, OR(@cell = "Green", @cell = "Yellow")) / COUNTIFS(Category:Category, @cell = "Administrative Staff")
-
Thanks much. Works like a charm
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 422 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!