计算父行如果完成日期current month
I am trying to create a formula that will count the finish dates in my parent rows if it falls in the current month.
I know how to use the month formula but I would have to update that every month and ideally, the current month formula will follow the calendar, thus not requiring me to update at the first of every month.
Answers
-
David Tutwiler Overachievers Alumni
I think you're looking for:
MONTH(TODAY())
That should return the current month number to be compared with your other dates.
Help Article Resources
Categories
Check out theFormula Handbook template!
<\/p>
Generally speaking, the has function is more designed to work with finding a single text string in a range of multi-select cells. In this case you are working backwards. You are wanting to find the options within a single multi-select cell in a series of text string cells. Flipping the search value and range around backwards should give you backwards functionality.<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":109109,"type":"question","name":"Trouble Setting Up a Workflow Automation Asking for Additional Information","excerpt":"I want to send an individual in a row a request to provide updated information to a sheet using a workflow form once the Send Request is checked. However, when trying to select the \"Send to Contacts in a Cell\" it doesn't give me the option to select a contact field with their email. Also, I want to pre-populate their…","snippet":"I want to send an individual in a row a request to provide updated information to a sheet using a workflow form once the Send Request is checked. However, when trying to select…","categoryID":322,"dateInserted":"2023-08-17T17:06:21+00:00","dateUpdated":null,"dateLastComment":"2023-08-17T20:09:43+00:00","insertUserID":143133,"insertUser":{"userID":143133,"name":"tiernosc","title":"Dr.","url":"https:\/\/community.smartsheet.com\/profile\/tiernosc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/A4IB9V0NPVJS\/n86WWQNSXCC15.jpg","dateLastActive":"2023-08-17T20:32:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-17T20:24:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":21,"score":null,"hot":3384596764,"url":"https:\/\/community.smartsheet.com\/discussion\/109109\/trouble-setting-up-a-workflow-automation-asking-for-additional-information","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109109\/trouble-setting-up-a-workflow-automation-asking-for-additional-information","format":"Rich","lastPost":{"discussionID":109109,"commentID":391276,"name":"Re: Trouble Setting Up a Workflow Automation Asking for Additional Information","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391276#Comment_391276","dateInserted":"2023-08-17T20:09:43+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-17T20:24:23+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/8KNRVZB43RA6\/screenshot.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-17T19:40:09+00:00","dateAnswered":"2023-08-17T17:54:48+00:00","acceptedAnswers":[{"commentID":391228,"body":"
Make sure that column is set as a contact type column.<\/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":109096,"type":"question","name":"I want my formula to count the blank cells in another sheet and also by a particular status","excerpt":"=COUNTIF(AND(NOT(ISBLANK({My sheet - Unit}),{My sheet - Status}, \"New Request\")))","snippet":"=COUNTIF(AND(NOT(ISBLANK({My sheet - Unit}),{My sheet - Status}, \"New Request\")))","categoryID":322,"dateInserted":"2023-08-17T14:53:18+00:00","dateUpdated":null,"dateLastComment":"2023-08-17T19:08:26+00:00","insertUserID":131821,"insertUser":{"userID":131821,"name":"Melitta","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Melitta","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7FjR-2zeSSY!zOlQs_Tjxjo!J3yyx3hqT9S","dateLastActive":"2023-08-17T18:49:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":66106,"lastUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-08-17T20:48:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":36,"score":null,"hot":3384585104,"url":"https:\/\/community.smartsheet.com\/discussion\/109096\/i-want-my-formula-to-count-the-blank-cells-in-another-sheet-and-also-by-a-particular-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109096\/i-want-my-formula-to-count-the-blank-cells-in-another-sheet-and-also-by-a-particular-status","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109096,"commentID":391252,"name":"Re: I want my formula to count the blank cells in another sheet and also by a particular status","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391252#Comment_391252","dateInserted":"2023-08-17T19:08:26+00:00","insertUserID":66106,"insertUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-08-17T20:48:57+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-17T18:36:02+00:00","dateAnswered":"2023-08-17T17:30:25+00:00","acceptedAnswers":[{"commentID":391213,"body":"
