Hospitality

0, \"no\", \"yes\") This formula pull in a 'yes' for anything that is due in the next 7 days, which is not quite what I'm looking for. Is it possible to determine…","categoryID":322,"dateInserted":"2019-05-02T10:18:46+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-05-03T11:59:54+00:00","insertUserID":71481,"insertUser":{"userID":71481,"name":"Andrea Mayer","url":"https:\/\/community.smartsheet.com\/profile\/Andrea%20Mayer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-12\/70\/13\/n7013e5bc085aca330cd32c80e0bacae1.jpg","dateLastActive":"2023-04-11T21:55:11+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":655,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/47231\/formula-to-determine-is-something-is-due-this-week","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/47231\/formula-to-determine-is-something-is-due-this-week","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":220,"urlcode":"hospitality","name":"Hospitality"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"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}]},{"discussionID":216,"type":"discussion","name":"Displaying multiple column values in Calendar view","excerpt":"I am storing data related to issues in the smartsheets. How can I show the issue number and priority in the calendar view?","categoryID":317,"dateInserted":"2015-04-30T23:52:32+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-05-01T17:22:05+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":71411,"lastUser":{"userID":71411,"name":"Lou Molinari","url":"https:\/\/community.smartsheet.com\/profile\/Lou%20Molinari","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-05-14T10:32:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":853,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/216\/displaying-multiple-column-values-in-calendar-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/216\/displaying-multiple-column-values-in-calendar-view","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":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"},{"tagID":507,"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":47026,"type":"discussion","name":"Requiring Approval when Dates Change","excerpt":"Hello community - I currently have an approval request enabled that notifies me via email once a day whenever a date in the Due Date column is changed. I also have a dashboard that shows me whenever an approval is needed and would like to eliminate the emails coming in to advise me. Is there a way to set up a column that…","categoryID":321,"dateInserted":"2019-04-30T15:13:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-05-01T10:04:21+00:00","insertUserID":71481,"insertUser":{"userID":71481,"name":"Andrea Mayer","url":"https:\/\/community.smartsheet.com\/profile\/Andrea%20Mayer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-12\/70\/13\/n7013e5bc085aca330cd32c80e0bacae1.jpg","dateLastActive":"2023-04-11T21:55:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T14:46:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":132,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/47026\/requiring-approval-when-dates-change","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/47026\/requiring-approval-when-dates-change","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":220,"urlcode":"hospitality","name":"Hospitality"},{"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}]},{"discussionID":45576,"type":"discussion","name":"T-shirt size icons for visual icons?","excerpt":"Would love to have S\/M\/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum team","categoryID":321,"dateInserted":"2019-04-10T14:57:30+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-10T15:23:47+00:00","insertUserID":84946,"insertUser":{"userID":84946,"name":"ANakamura","url":"https:\/\/community.smartsheet.com\/profile\/ANakamura","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!W2leX7QSWjo!bPnd29xFSL4!D-wJyk-dpmy","dateLastActive":"2021-02-26T20:04:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T14:46:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":206,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/45576\/t-shirt-size-icons-for-visual-icons","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45576\/t-shirt-size-icons-for-visual-icons","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":216,"urlcode":"non-profit","name":"Non-profit"},{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":220,"urlcode":"hospitality","name":"Hospitality"},{"tagID":223,"urlcode":"publish","name":"Publish"},{"tagID":234,"urlcode":"health-care","name":"Healthcare"},{"tagID":249,"urlcode":"education","name":"Education"},{"tagID":263,"urlcode":"government","name":"Government"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":266,"urlcode":"real-estate","name":"Real Estate"},{"tagID":271,"urlcode":"services","name":"Services"},{"tagID":274,"urlcode":"legal","name":"Legal"},{"tagID":279,"urlcode":"marketing","name":"Marketing"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"},{"tagID":492,"urlcode":"media-entertainment","name":"Media & Entertainment"}],"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}">