COUNTIFS question, stumped
I'm trying to count how many "Yes" is in the column (options are Yes and No). The column name is "Do you plan to stay overnight May 1st?"
I feel like this is probably simple but I've been stuck on it for 2 weeks. HALP
Best Answers
-
Carson Penticuff ✭✭✭✭✭
=COUNTIFS([Do you plan to stay overnight May 1st?]:[Do you plan to stay overnight May 1st?], "Yes")
-
Paul Newcome ✭✭✭✭✭✭
Sounds like you just need a basic COUNTIFS.
=COUNTIFS([Column Name]:[Column name], @cell = "Yes")
Answers
-
Carson Penticuff ✭✭✭✭✭
=COUNTIFS([Do you plan to stay overnight May 1st?]:[Do you plan to stay overnight May 1st?], "Yes")
-
Paul Newcome ✭✭✭✭✭✭
Sounds like you just need a basic COUNTIFS.
=COUNTIFS([Column Name]:[Column name], @cell = "Yes")
-
mwd ✭
Thank you!!!
-
Paul Newcome ✭✭✭✭✭✭
Help Article Resources
Categories
If \"Yesterday\" and \"Today\" are the only text values you end up with, then this formula would do what you're after:<\/p>
=IF([Last Updated]@row = \"Yesterday\", TODAY(-1), IF([Last Updated]@row = \"Today\", TODAY(), [Last Updated]@row))<\/p>
Ironically, typing Yesterday\/Today directly into a date column in Smartsheet will give the relevant date (as will last\/previous\/next <insert day>) but I don't know if the Jira integration would support that or you'd need to use a helper column with the formula as above.<\/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":108819,"type":"question","name":"Fill in a cell based on another cell's value?","excerpt":"Hello, I'm tracking participation of a program on my sheet as a \"participation %\" column. There is another column called \"participation status\" to make it easy for the managers to know if their employee is on track with participation or not. I'm trying to set up the participation status column so that if the participation…","snippet":"Hello, I'm tracking participation of a program on my sheet as a \"participation %\" column. There is another column called \"participation status\" to make it easy for the managers to…","categoryID":322,"dateInserted":"2023-08-10T20:29:21+00:00","dateUpdated":null,"dateLastComment":"2023-08-10T21:09:33+00:00","insertUserID":164943,"insertUser":{"userID":164943,"name":"ciera_wolinski","url":"https:\/\/community.smartsheet.com\/profile\/ciera_wolinski","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zB8mc3uvxuo!pXcnKVOwqro!qMp2YpGJXFb","dateLastActive":"2023-08-10T21:06:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164943,"lastUser":{"userID":164943,"name":"ciera_wolinski","url":"https:\/\/community.smartsheet.com\/profile\/ciera_wolinski","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zB8mc3uvxuo!pXcnKVOwqro!qMp2YpGJXFb","dateLastActive":"2023-08-10T21:06:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":46,"score":null,"hot":3383402334,"url":"https:\/\/community.smartsheet.com\/discussion\/108819\/fill-in-a-cell-based-on-another-cells-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108819\/fill-in-a-cell-based-on-another-cells-value","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":108819,"commentID":390127,"name":"Re: Fill in a cell based on another cell's value?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390127#Comment_390127","dateInserted":"2023-08-10T21:09:33+00:00","insertUserID":164943,"insertUser":{"userID":164943,"name":"ciera_wolinski","url":"https:\/\/community.smartsheet.com\/profile\/ciera_wolinski","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zB8mc3uvxuo!pXcnKVOwqro!qMp2YpGJXFb","dateLastActive":"2023-08-10T21:06:11+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-08-10T21:09:38+00:00","dateAnswered":"2023-08-10T20:58:08+00:00","acceptedAnswers":[{"commentID":390125,"body":"
=SUMIFS([Actual Charges]2:[Actual Charges]60, [SOW Reference]2:[SOW Reference]60, \"IPO PMO\")<\/p>