@Hobson_K<\/a> <\/p>If you don't have this already, I would add a helper column [Last MonthNum]<\/p>
[Last MonthNum] <\/p>
=IF(MONTH([Date of App Window]@row) = 1, 12, MONTH([Date of App Window]@row) - 1)<\/p>
For your Last Month\/Year string<\/p>
*I assumed you used a nested IF to get your original Month names. If instead you have a lookup table we can use that again. Rather than do the Month-Name and Year in two columns, I did it one<\/p>
=IF([Last MonthNum]@row = 1, \"January \" + VALUE(YEAR([Date of App Window]@row)), IF([Last MonthNum]@row = 2, \"February \" + VALUE(YEAR([Date of App Window]@row)), IF([Last MonthNum]@row = 3, \"March \" + VALUE(YEAR([Date of App Window]@row)), IF([Last MonthNum]@row = 4, \"April \" + VALUE(YEAR([Date of App Window]@row)), IF([Last MonthNum]@row = 5, \"May \" + VALUE(YEAR([Date of App Window]@row)), IF([Last MonthNum]@row = 6, \"June \" + VALUE(YEAR([Date of App Window]@row)), IF([Last MonthNum]@row = 7, \"July \" + VALUE(YEAR([Date of App Window]@row)), IF([Last MonthNum]@row = 8, \"August \" + VALUE(YEAR([Date of App Window]@row)), IF([Last MonthNum]@row = 9, \"September \" + VALUE(YEAR([Date of App Window]@row)), IF([Last MonthNum]@row = 10, \"October \" + VALUE(YEAR([Date of App Window]@row)), IF([Last MonthNum]@row = 11, \"November \" + VALUE(YEAR([Date of App Window]@row)), IF([Last MonthNum]@row = 12, \"December \" + VALUE(YEAR([Date of App Window]@row) - 1)))))))))))))<\/p>
Will this work for you?<\/p>
Kelly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-21 15:52:56","updateUser":{"userID":151575,"name":"Hobson_K","url":"https:\/\/community.smartsheet.com\/profile\/Hobson_K","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-21T16:37:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":94501,"type":"question","name":"COUNTIFS with HAS Referencing Another Sheet","excerpt":"Good morning, Community! I'm struggling with a formula and could use some help. On the **CBO CBA Case Tracker sheet, the Priority populations served column is a multi-select with 21 options. The Priority Populations Served sheet has a Population column with each of the 21 values as I thought it would be easier to…","categoryID":322,"dateInserted":"2022-08-20T13:53:32+00:00","dateUpdated":null,"dateLastComment":"2022-08-20T15:10:21+00:00","insertUserID":11066,"insertUser":{"userID":11066,"name":"Chris Hallo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Hallo","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zEjYc4xZyTY!nCPbnzgtiHw!3apta-6OY7C","dateLastActive":"2022-08-20T15:09:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11066,"lastUser":{"userID":11066,"name":"Chris Hallo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Hallo","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zEjYc4xZyTY!nCPbnzgtiHw!3apta-6OY7C","dateLastActive":"2022-08-20T15:09:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3322013033,"url":"https:\/\/community.smartsheet.com\/discussion\/94501\/countifs-with-has-referencing-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94501\/countifs-with-has-referencing-another-sheet","format":"Rich","lastPost":{"discussionID":94501,"commentID":340520,"name":"Re: COUNTIFS with HAS Referencing Another Sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/340520#Comment_340520","dateInserted":"2022-08-20T15:10:21+00:00","insertUserID":11066,"insertUser":{"userID":11066,"name":"Chris Hallo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Hallo","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zEjYc4xZyTY!nCPbnzgtiHw!3apta-6OY7C","dateLastActive":"2022-08-20T15:09:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/62KW6UY7E7WZ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-20T15:09:55+00:00","dateAnswered":"2022-08-20T14:45:32+00:00","acceptedAnswers":[{"commentID":340518,"body":"
I would say try Contains(. <\/p>
=countif([Priority Population Served]:[Priority Population Served], CONTAINS(\"Aging\/Older Populations\",@cell))<\/p>
That will count the number of times that phrase or word appears in that column. I would suggest summarizing this data on another sheet as the 'sheet summary fields' on the side bar can not be used for very much as far as dashboards and reports go.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-20 15:09:55","updateUser":{"userID":11066,"name":"Chris Hallo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Hallo","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zEjYc4xZyTY!nCPbnzgtiHw!3apta-6OY7C","dateLastActive":"2022-08-20T15:09:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":94388,"type":"question","name":"Nested Formulla","excerpt":"Hello, I am trying to create a formulla, perhaps with IF(AND). I have 4 columns. Each column with the following dropdown: Yes, No, Sometime, N\/A. The columns are: Criteria A Criteria B Criteria C Criteria D What i need to happen is the following: If criteria A to B are all \"yes\", then the overall answer should be \"yes\" If…","categoryID":322,"dateInserted":"2022-08-17T23:58:33+00:00","dateUpdated":null,"dateLastComment":"2022-08-21T10:55:33+00:00","insertUserID":137906,"insertUser":{"userID":137906,"name":"Vinton Douglas","url":"https:\/\/community.smartsheet.com\/profile\/Vinton%20Douglas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-21T10:52:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137906,"lastUser":{"userID":137906,"name":"Vinton Douglas","url":"https:\/\/community.smartsheet.com\/profile\/Vinton%20Douglas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-21T10:52:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":41,"score":null,"hot":3321864846,"url":"https:\/\/community.smartsheet.com\/discussion\/94388\/nested-formulla","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94388\/nested-formulla","format":"Rich","lastPost":{"discussionID":94388,"commentID":340531,"name":"Re: Nested Formulla","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/340531#Comment_340531","dateInserted":"2022-08-21T10:55:33+00:00","insertUserID":137906,"insertUser":{"userID":137906,"name":"Vinton Douglas","url":"https:\/\/community.smartsheet.com\/profile\/Vinton%20Douglas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-21T10:52:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-20T09:10:52+00:00","dateAnswered":"2022-08-18T20:50:47+00:00","acceptedAnswers":[{"commentID":340307,"body":"
Ok. In that case you would have something like this:<\/p>
<\/p>
=IF(COUNTIFS([Criteria A]@row:[Criteria D]@row, @cell = \"N\/A\") = 4, \"N\/A\", IF(COUNTIFS([Criteria A]@row:[Criteria D]@row, OR(@cell = \"No\", @cell = \"N\/A\")) = 4, \"No\", IF(COUNTIFS([Criteria A]@row:[Criteria D]@row, OR(@cell = \"Yes\", @cell = \"N\/A\")) = 4, \"Yes\", \"Sometimes\")))<\/p>
<\/p>
If they are all N\/A then N\/A<\/p>
If they are a mix of No and N\/A then No<\/p>
If they are a mix of Yes and N\/A then Yes<\/p>
If all else is false (yes and no mixed) then Sometimes<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-20 09:10:52","updateUser":{"userID":137906,"name":"Vinton Douglas","url":"https:\/\/community.smartsheet.com\/profile\/Vinton%20Douglas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-21T10:52:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
julieg ✭
吉纳维芙P。 员工管理
