Trying to find the percentage of time that a word appears in a column.
I have a column with Red, Green and Yellow but I want to find the percentage of times the word Red is used.
I tried =COUNTIF([All screeners present at event]:[All screeners present at event], "Red"), /COUNT([All screeners present at event]:[All screeners present at event])) but I'm getting an error
Answers
-
ShelbyWarren ✭✭✭✭✭
@Connie CochranTry this:
=(COUNTIF([All screeners present at event]:[All screeners present at event], "Red")) / COUNT([All screeners present at event]:[All screeners present at event])
-
Connie Cochran ✭✭✭✭Thank you but I am still getting an error saying #UNPARSEBLE
-
ShelbyWarren ✭✭✭✭✭
@Connie CochranStrange. It's working for me in the example below. Can you share a screenshot of the sheet/columns?
-
Connie Cochran ✭✭✭✭
If figured it out, I had space that I shouldn't have. Thank you so much for your help!!!!
-
ShelbyWarren ✭✭✭✭✭
@Connie CochranGlad it worked out!
-
Connie Cochran ✭✭✭✭
What if instead of the word red I just wanted to find the percentage of all cells that had a value in it some cells are blank. Like there are 50 cells but only 5 of them have anything in it =10%
-
ShelbyWarren ✭✭✭✭✭
@Connie CochranDoes the primary column of the sheet always have a value in it? Or is there another column that always has a value in it? If so, use this formula but replace the "Primary Column" with a column that always will have a value:
=(COUNT([All screeners present at event]:[All screeners present at event]) / (COUNT([Primary Column]:[Primary Column])))
-
Connie Cochran ✭✭✭✭
AMAZING! Thank you so much!
Help Article Resources
Categories
Check out theFormula Handbook template!
I think this should work:<\/p>
=IF(COUNTIF(Referencia:Referencia, Referencia@row) > 1, 1)<\/p>
Have a great day.<\/p>
Matt<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107890,"type":"question","name":"Need Help with Formula to Roll Up and Average Schedule Health.","excerpt":"Need Help with Formula to Roll Up and Average Schedule Health. I have one that now updates the Schedule Health RYG based on the Start Date\/End Date and Task Status. Next, I am trying to roll up\/average those Individual Task schedule health values to an overall Phase schedule health value and then ultimately to the Overall…","snippet":"Need Help with Formula to Roll Up and Average Schedule Health. I have one that now updates the Schedule Health RYG based on the Start Date\/End Date and Task Status. Next, I am…","categoryID":322,"dateInserted":"2023-07-21T00:56:52+00:00","dateUpdated":null,"dateLastComment":"2023-07-23T08:28:05+00:00","insertUserID":163738,"insertUser":{"userID":163738,"name":"BArmendariz","url":"https:\/\/community.smartsheet.com\/profile\/BArmendariz","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtcJ5xYSxEGHhOSSWfKvut9ttlA26d6GuoryTax_h13HbQ=s96-c","dateLastActive":"2023-07-21T16:10:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":80301,"lastUser":{"userID":80301,"name":"Debbie Sawyer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Sawyer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-02\/6f\/d1\/n6fd11e91b71000f2b152e84c8f072631.jpg","dateLastActive":"2023-07-23T08:45:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":42,"score":null,"hot":3380006697,"url":"https:\/\/community.smartsheet.com\/discussion\/107890\/need-help-with-formula-to-roll-up-and-average-schedule-health","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107890\/need-help-with-formula-to-roll-up-and-average-schedule-health","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107890,"commentID":386548,"name":"Re: Need Help with Formula to Roll Up and Average Schedule Health.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386548#Comment_386548","dateInserted":"2023-07-23T08:28:05+00:00","insertUserID":80301,"insertUser":{"userID":80301,"name":"Debbie Sawyer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Sawyer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-02\/6f\/d1\/n6fd11e91b71000f2b152e84c8f072631.jpg","dateLastActive":"2023-07-23T08:45:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-21T16:11:26+00:00","dateAnswered":"2023-07-21T12:51:20+00:00","acceptedAnswers":[{"commentID":386383,"body":"
