日程表视图

and < on the date but am not sure how to do this. I could also reference the Monday DATE() +4. Anyone have any ideas?","categoryID":318,"dateInserted":"2016-04-22T14:37:03+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-04-25T10:27:52+00:00","insertUserID":5480,"insertUser":{"userID":5480,"name":"Zach Alexander","url":"https:\/\/community.smartsheet.com\/profile\/Zach%20Alexander","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-04-25T10:26:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":5480,"lastUser":{"userID":5480,"name":"Zach Alexander","url":"https:\/\/community.smartsheet.com\/profile\/Zach%20Alexander","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-04-25T10:26:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":9,"countViews":903,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/4833\/countif-formula-for-week-of","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4833\/countif-formula-for-week-of","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"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":4812,"type":"discussion","name":"Reports \/ Master Calendar","excerpt":"Hi there, it's me again. So here's the thing... We are a small test facility. We are trying to track jobs that are nothing like eachother using the same equipment and people resources. Sometimes we have 2 people resources on the same job. I know there currently isn't anyway to put 2 people on the same job and that I would…","categoryID":318,"dateInserted":"2016-04-20T13:15:47+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-04-25T08:07:08+00:00","insertUserID":6279,"insertUser":{"userID":6279,"name":"Heidi Decker","url":"https:\/\/community.smartsheet.com\/profile\/Heidi%20Decker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-19T11:25:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":6279,"lastUser":{"userID":6279,"name":"Heidi Decker","url":"https:\/\/community.smartsheet.com\/profile\/Heidi%20Decker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-19T11:25:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":61,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/4812\/reports-master-calendar","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4812\/reports-master-calendar","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"}],"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":4816,"type":"discussion","name":"Calendar sync","excerpt":"Can I sync the calendar with my Google calendar so only tasks related to myself show up?","categoryID":318,"dateInserted":"2016-04-20T22:25:34+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-04-22T14:28:06+00:00","insertUserID":6357,"insertUser":{"userID":6357,"name":"Nathan Hall","url":"https:\/\/community.smartsheet.com\/profile\/Nathan%20Hall","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-04-20T22:23:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":177,"lastUser":{"userID":177,"name":"Travis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Travis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9b\/30\/n9b30d18a803dd0ccefe2f8f2d8765390.jpg","dateLastActive":"2020-01-21T20:47:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":2,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/4816\/calendar-sync","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4816\/calendar-sync","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":241,"urlcode":"Calendar","name":"Calendar View"}],"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":4760,"type":"discussion","name":"\"Processing\" Today date in date range.","excerpt":"Good day all, I am collecting information via a webform and need some assistance with the reporting side of things. On the webform i am asking among other things to provide me with a startdate and a finishdate. My aim is to have automated reporting in the backend that will check if date Today is in range of the user…","categoryID":318,"dateInserted":"2016-04-14T09:10:41+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-04-18T07:28:44+00:00","insertUserID":6258,"insertUser":{"userID":6258,"name":"Tom Keunen","url":"https:\/\/community.smartsheet.com\/profile\/Tom%20Keunen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-04-14T09:07:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":6258,"lastUser":{"userID":6258,"name":"Tom Keunen","url":"https:\/\/community.smartsheet.com\/profile\/Tom%20Keunen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-04-14T09:07:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":2,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/4760\/processing-today-date-in-date-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4760\/processing-today-date-in-date-range","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":265,"urlcode":"Reports","name":"Reports"}],"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":4688,"type":"discussion","name":"Dates not lining up","excerpt":"My editorail calendar isn't lining up when I sort by date. My April dates are below July. I'm not sure what's happening with the formatting. ","categoryID":318,"dateInserted":"2016-04-07T14:25:54+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-04-08T19:00:04+00:00","insertUserID":6172,"insertUser":{"userID":6172,"name":"Celecia Partap","url":"https:\/\/community.smartsheet.com\/profile\/Celecia%20Partap","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-04-07T14:19:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":177,"lastUser":{"userID":177,"name":"Travis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Travis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9b\/30\/n9b30d18a803dd0ccefe2f8f2d8765390.jpg","dateLastActive":"2020-01-21T20:47:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":3,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/4688\/dates-not-lining-up","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4688\/dates-not-lining-up","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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":221,"type":"discussion","name":"How can I get Calendar view info to wrap so it can display more than 20 characters?","excerpt":"I want to be able to show more than the 20-25 characters limited in the display of a calendar entry. e.g., I need to be able to show an \"Issue No. (10 characters) + an Impact\" which can be a list of multiple things. I would not mind if it wraps around into a second row as long as it displays all the information needed by…","categoryID":317,"dateInserted":"2015-05-01T13:23:10+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-04-08T12:54:07+00:00","insertUserID":1286,"insertUser":{"userID":1286,"name":"Arvind Solanki","url":"https:\/\/community.smartsheet.com\/profile\/Arvind%20Solanki","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-06-11T14:30:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":177,"lastUser":{"userID":177,"name":"Travis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Travis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9b\/30\/n9b30d18a803dd0ccefe2f8f2d8765390.jpg","dateLastActive":"2020-01-21T20:47:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":171,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/221\/how-can-i-get-calendar-view-info-to-wrap-so-it-can-display-more-than-20-characters","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/221\/how-can-i-get-calendar-view-info-to-wrap-so-it-can-display-more-than-20-characters","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":220,"urlcode":"Hospitality","name":"Hospitality"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":274,"urlcode":"Legal","name":"Legal"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}">