=DATE(2018, 10, 1), {End Date}, <=DATE(2018, 10, 31), {Classification}, =\"Lost Time Injury\") Wondering if there is an easier way to get this? This is pretty tedious when you're just looking for what happened in a particular month of the year. Regards Steve","categoryID":322,"dateInserted":"2018-10-16T01:05:03+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-22T07:40:50+00:00","insertUserID":65251,"insertUser":{"userID":65251,"name":"Steve Moss","url":"https:\/\/community.smartsheet.com\/profile\/Steve%20Moss","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-10\/a0\/c9\/na0c9ffb5e4728b9c26910d314f87e7b9.jpg","dateLastActive":"2018-12-06T19:32:34+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":"2022-08-05T20:10:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":1212,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/33871\/countifs-by-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/33871\/countifs-by-month","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]},{"discussionID":34281,"type":"discussion","name":"Formula: If Status Changes to Something After Date","excerpt":"I'd like help in creating a formula that depends on another cell changing to a specific status, not if it is that status already. E.g. to have a checkbox get checked if the status balls of a neighboring cell turn red (after a certain time and date- the time and date of which I input the formula), but not if they were red…","categoryID":322,"dateInserted":"2018-10-21T23:54:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-22T03:49:09+00:00","insertUserID":59656,"insertUser":{"userID":59656,"name":"SYSPK","title":"","url":"https:\/\/community.smartsheet.com\/profile\/SYSPK","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-09\/8a\/a2\/n8aa26d196e6672ed722182cfae07f814.jpg","dateLastActive":"2022-03-14T18:23:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-08-06T13:55:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":14,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/34281\/formula-if-status-changes-to-something-after-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/34281\/formula-if-status-changes-to-something-after-date","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]},{"discussionID":33306,"type":"discussion","name":"Turn off Auto-Save on Android App","excerpt":"Is it possible to turn the auto-save function on the Smartsheet Android app 'off'? When our guys use the app on their tablets when they have a weak connection, after each cell there is a long wait untill it has saved. is it possible to turn this off, and maybe just save it when required, or when you leave the sheet or…","categoryID":322,"dateInserted":"2018-10-08T05:37:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-21T16:36:22+00:00","insertUserID":53396,"insertUser":{"userID":53396,"name":"grant53396","url":"https:\/\/community.smartsheet.com\/profile\/grant53396","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-23T20:10:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-08-06T13:55:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":185,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/33306\/turn-off-auto-save-on-android-app","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/33306\/turn-off-auto-save-on-android-app","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":214,"urlcode":"Search","name":"Search"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":246,"urlcode":"Mobile","name":"Mobile"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"tagID":301,"urlcode":"Comments and Conversations","name":"Comments and Conversations"}],"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}]},{"discussionID":33936,"type":"discussion","name":"Nested IF Statement to Produce a Date?","excerpt":"I am really struggling with complex Smartsheet formula's. I am trying to produce a start date for different action items based on the below logic (also attaching a screen shot for reference): If \"Isolated or Existing Market\" = Isolated, then Start Date Test = (Grand Opening) - 10 days If \"Isolated or Existing Market\" =…","categoryID":322,"dateInserted":"2018-10-16T17:02:33+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-20T03:57:02+00:00","insertUserID":53671,"insertUser":{"userID":53671,"name":"Tessa Heath","url":"https:\/\/community.smartsheet.com\/profile\/Tessa%20Heath","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-22T13:59:32+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-08-06T13:55:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":14,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/33936\/nested-if-statement-to-produce-a-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/33936\/nested-if-statement-to-produce-a-date","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-10\/de\/88\/de889c4cde757058b32e39a54b53e7ce.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"Smartsheet Test.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":276,"urlcode":"Retail","name":"Retail"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">
I could solve the issue. It was a simple spelling mistake or difference between the two sheets.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-06 20:28:39","updateUser":{"userID":151036,"name":"Jörg Schmidt1","url":"https:\/\/community.smartsheet.com\/profile\/J%C3%B6rg%20Schmidt1","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hJjVoY907bY!!P7w61eHMiE7","dateLastActive":"2022-08-06T20:26:27+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":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":93987,"type":"question","name":"how can i copy a value from one cell to another in the same sheet","excerpt":"I have the above project plan setup The FOCUS AREA is a dropdown value. When i add children to a parent, i want the children to inherit the parents FOCUS AREA value. i created a helper column to identify children and that childs parent value for focus area. How can i automate the copy over AND still allow the user to pick…","categoryID":322,"dateInserted":"2022-08-05T17:50:56+00:00","dateUpdated":null,"dateLastComment":"2022-08-05T20:20:49+00:00","insertUserID":120623,"insertUser":{"userID":120623,"name":"Umesh Shah","url":"https:\/\/community.smartsheet.com\/profile\/Umesh%20Shah","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!B_DAgW7inuQ!GutBH5L31vo!a4sw_iKY2Cf","dateLastActive":"2022-08-05T20:19:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":120623,"lastUser":{"userID":120623,"name":"Umesh Shah","url":"https:\/\/community.smartsheet.com\/profile\/Umesh%20Shah","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!B_DAgW7inuQ!GutBH5L31vo!a4sw_iKY2Cf","dateLastActive":"2022-08-05T20:19:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":14,"score":null,"hot":3319453905,"url":"https:\/\/community.smartsheet.com\/discussion\/93987\/how-can-i-copy-a-value-from-one-cell-to-another-in-the-same-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93987\/how-can-i-copy-a-value-from-one-cell-to-another-in-the-same-sheet","format":"Rich","lastPost":{"discussionID":93987,"commentID":338859,"name":"Re: how can i copy a value from one cell to another in the same sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/338859#Comment_338859","dateInserted":"2022-08-05T20:20:49+00:00","insertUserID":120623,"insertUser":{"userID":120623,"name":"Umesh Shah","url":"https:\/\/community.smartsheet.com\/profile\/Umesh%20Shah","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!B_DAgW7inuQ!GutBH5L31vo!a4sw_iKY2Cf","dateLastActive":"2022-08-05T20:19:13+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\/353Y6W0RK5SL\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-05T20:21:04+00:00","dateAnswered":"2022-08-05T19:49:10+00:00","acceptedAnswers":[{"commentID":338851,"body":"
You would use<\/p>
=PARENT([Focus Area]@row)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-05 20:21:04","updateUser":{"userID":120623,"name":"Umesh Shah","url":"https:\/\/community.smartsheet.com\/profile\/Umesh%20Shah","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!B_DAgW7inuQ!GutBH5L31vo!a4sw_iKY2Cf","dateLastActive":"2022-08-05T20:19:13+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":93984,"type":"question","name":"Multiselect Dropdown Parsing","excerpt":"Hello all, I have 3 columns in a sheet. 1 is a multi-select dropdown (\"MSD\"), 1 is a single contact (\"SC\"), and 1 is a multi-select contact (\"MSC\"). In the SC, I want to take the first dropdown value from the MSD and use it to index match a value from another sheet. In the MSC, then I want to take the remaining values from…","categoryID":322,"dateInserted":"2022-08-05T17:28:01+00:00","dateUpdated":null,"dateLastComment":"2022-08-05T19:48:02+00:00","insertUserID":151077,"insertUser":{"userID":151077,"name":"Allen M Vance","url":"https:\/\/community.smartsheet.com\/profile\/Allen%20M%20Vance","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wvjQf0zrtpU!HVPSXzyfi_0!-X5Gyhg_Kh5","dateLastActive":"2022-08-05T22:14:05+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":"2022-08-05T20:10:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":10,"score":null,"hot":3319449963,"url":"https:\/\/community.smartsheet.com\/discussion\/93984\/multiselect-dropdown-parsing","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93984\/multiselect-dropdown-parsing","format":"Rich","lastPost":{"discussionID":93984,"commentID":338850,"name":"Re: Multiselect Dropdown Parsing","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/338850#Comment_338850","dateInserted":"2022-08-05T19:48:02+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":"2022-08-05T20:10:09+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-05T22:14:17+00:00","dateAnswered":"2022-08-05T19:48:02+00:00","acceptedAnswers":[{"commentID":338850,"body":"
Technically yes. You can pull these values in based on the multi-select dropdown, but...<\/p>
<\/p>
We cannot currently use formulas to populate multiple USABLE contacts in a single cell even if the column is set to allow multiple. It will simply generate a text string and won't be usable in automations for notifications, update requests, etc..<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-05 22:14:17","updateUser":{"userID":151077,"name":"Allen M Vance","url":"https:\/\/community.smartsheet.com\/profile\/Allen%20M%20Vance","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wvjQf0zrtpU!HVPSXzyfi_0!-X5Gyhg_Kh5","dateLastActive":"2022-08-05T22:14:05+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":[]}">
