Discussions
=[PTO Start Date]@row, [PTO End Date]:[PTO End Date],…","categoryID":322,"dateInserted":"2023-06-27T00:08:53+00:00","dateUpdated":"2023-06-27T00:09:29+00:00","dateLastComment":"2023-06-28T09:22:49+00:00","insertUserID":129131,"insertUser":{"userID":129131,"name":"Christina09","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christina09","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T18:31:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":129131,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":32,"score":null,"hot":3375769902,"url":"https:\/\/community.smartsheet.com\/discussion\/106933\/formula-that-combine-names-that-falls-into-the-selected-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106933\/formula-that-combine-names-that-falls-into-the-selected-dates","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-27T15:01:56+00:00","acceptedAnswers":[]}},"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":106266,"type":"question","name":"result with index\/match but not index\/collect","excerpt":"Hi, I have a formula with multiple conditions, so I used index\/collect to pull the data. However, that didn't pull the data. Basically, if the ID# in sheet A matches sheet B and the details column in sheet A is not blank, it should pull the details in sheet A. =IFERROR(INDEX(COLLECT({details}, {ID#}, [ID#]@row, {details},…","categoryID":322,"dateInserted":"2023-06-09T14:04:19+00:00","dateUpdated":null,"dateLastComment":"2023-06-13T15:36:59+00:00","insertUserID":129131,"insertUser":{"userID":129131,"name":"Christina09","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christina09","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T18:31:44+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":11,"countViews":93,"score":null,"hot":3372996678,"url":"https:\/\/community.smartsheet.com\/discussion\/106266\/result-with-index-match-but-not-index-collect","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106266\/result-with-index-match-but-not-index-collect","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-13T16:45:03+00:00","dateAnswered":"2023-06-13T14:29:25+00:00","acceptedAnswers":[]}},"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":95606,"type":"discussion","name":"ENGAGE 2022!! IN PERSON YAY","excerpt":"YAY! Finally engage is in person! Great to finally meet the staff and the community rockstar! 😍","categoryID":336,"dateInserted":"2022-09-20T20:12:16+00:00","dateUpdated":null,"dateLastComment":"2022-09-26T18:50:19+00:00","insertUserID":129131,"insertUser":{"userID":129131,"name":"Christina09","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christina09","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T18:31:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":126614,"lastUser":{"userID":126614,"name":"Alison Clancy","title":"Community Engagement Manager II","url":"https:\/\/community.smartsheet.com\/profile\/Alison%20Clancy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nEFeH-a5APo!7Idee8avSzo!8w93-Gb3myE","dateLastActive":"2023-08-26T00:23:43+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":212,"score":1,"hot":3327923855,"url":"https:\/\/community.smartsheet.com\/discussion\/95606\/engage-2022-in-person-yay","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95606\/engage-2022-in-person-yay","format":"Rich","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":336,"name":"Events","url":"https:\/\/community.smartsheet.com\/categories\/events","allowedDiscussionTypes":[]},"tags":[{"tagID":355,"urlcode":"engage","name":"ENGAGE"}],"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":93607,"type":"question","name":"JOIN Muliple values dropdown menu","excerpt":"Hi, I have a simple JOIN formula to combine the cells on the right into a muli value dropdown menu column. However, for some reason, it will only show unique value and sometimes it wouldn't show it in order. Column \"Join Formula\" is a simple text\/number column, with the same formula as \"Join formula w\/ muli dropdown\". It…","categoryID":322,"dateInserted":"2022-07-26T18:12:35+00:00","dateUpdated":null,"dateLastComment":"2022-07-26T18:48:29+00:00","insertUserID":129131,"insertUser":{"userID":129131,"name":"Christina09","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christina09","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T18:31:44+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-26T00:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":187,"score":null,"hot":3317721064,"url":"https:\/\/community.smartsheet.com\/discussion\/93607\/join-muliple-values-dropdown-menu","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93607\/join-muliple-values-dropdown-menu","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/2XLSRVWUQW3V\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-07-26T18:48:29+00:00","acceptedAnswers":[]}},"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":93122,"type":"question","name":"Creating horizontal view for existing sheet","excerpt":"Hi, I'm trying to get sheet A (vertical view) into sheet B view (horizontal view). Sheet A: Sheet B: the helper column date is in txt\/number so it would match sheet A. Could anyone help? Thanks. :)","categoryID":322,"dateInserted":"2022-07-12T15:02:11+00:00","dateUpdated":null,"dateLastComment":"2022-07-15T23:02:06+00:00","insertUserID":129131,"insertUser":{"userID":129131,"name":"Christina09","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christina09","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T18:31:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":242,"score":null,"hot":3315564857,"url":"https:\/\/community.smartsheet.com\/discussion\/93122\/creating-horizontal-view-for-existing-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93122\/creating-horizontal-view-for-existing-sheet","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/VGSQ0WUGLDYQ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-07-26T18:54:07+00:00","dateAnswered":"2022-07-15T23:02:06+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"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":91297,"type":"question","name":"Is there a way to calculate the change of role in percentage?","excerpt":"Hi, I have a tracker, whenever the role\/status change, it'll copy to this sheet. I'm trying to find a formula to calculate the change % from coordinator to admin, and from admin to the coordinator. Is there a way to do so? TIA!","categoryID":322,"dateInserted":"2022-05-19T01:35:51+00:00","dateUpdated":"2022-05-19T01:40:01+00:00","dateLastComment":"2022-05-21T03:45:42+00:00","insertUserID":129131,"insertUser":{"userID":129131,"name":"Christina09","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christina09","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T18:31:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":129131,"lastUserID":129131,"lastUser":{"userID":129131,"name":"Christina09","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christina09","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T18:31:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":198,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/91297\/is-there-a-way-to-calculate-the-change-of-role-in-percentage","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91297\/is-there-a-way-to-calculate-the-change-of-role-in-percentage","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/5V6QQYGV7QZQ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-05-21T03:45:55+00:00","dateAnswered":"2022-05-20T16:44:00+00:00","acceptedAnswers":[]}},"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":89330,"type":"question","name":"Is there a way to not type DATE formula manually?","excerpt":"I have a sheet with the date as the column name and have a cross-sheet formula with SUMIFS and DATE. Is there a way I don't have to type the date manually? Unfortunately, I have over 100 columns that I need to modify the date to match the column 😥 You'll be a lifesaver if there is a way! Thank you in advance!!🙇♀️","categoryID":321,"dateInserted":"2022-03-24T03:18:52+00:00","dateUpdated":null,"dateLastComment":"2022-03-24T22:30:57+00:00","insertUserID":129131,"insertUser":{"userID":129131,"name":"Christina09","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christina09","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T18:31:44+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-26T00:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":93,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/89330\/is-there-a-way-to-not-type-date-formula-manually","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/89330\/is-there-a-way-to-not-type-date-formula-manually","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/8TNB6K18T3X0\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-03-24T18:51:56+00:00","dateAnswered":"2022-03-24T15:30:09+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":83625,"type":"question","name":"Team Vacation Planner - automation to notify if too many people are taking the same day off","excerpt":"Hi there! Is there any way smartsheet can set up an automation that if there are too many people taking the same day off it'll send an alert to me? I have a start date and end date column I also have another helper sheet with each day (excluding holiday, Saturday and Sunday) in each row and different departments as column.…","categoryID":322,"dateInserted":"2021-09-30T15:37:00+00:00","dateUpdated":null,"dateLastComment":"2022-03-04T22:25:16+00:00","insertUserID":129131,"insertUser":{"userID":129131,"name":"Christina09","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christina09","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T18:31:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":145602,"lastUser":{"userID":145602,"name":"Dio Fernandez","url":"https:\/\/community.smartsheet.com\/profile\/Dio%20Fernandez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-03-07T16:57:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":159,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/83625\/team-vacation-planner-automation-to-notify-if-too-many-people-are-taking-the-same-day-off","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/83625\/team-vacation-planner-automation-to-notify-if-too-many-people-are-taking-the-same-day-off","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/H1TVW4MLE25S\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-10-01T20:53:59+00:00","dateAnswered":"2021-10-01T20:53:53+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":215,"urlcode":"templates","name":"Templates"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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":false,"noCheckboxes":true}">