Sheets

\"\", {Site Visits…","categoryID":322,"dateInserted":"2023-09-21T16:33:29+00:00","dateUpdated":null,"dateLastComment":"2023-09-21T19:00:21+00:00","insertUserID":144966,"insertUser":{"userID":144966,"name":"kelceyg","title":"Associate Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/kelceyg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QOWM4DMFF87J\/n3NJCD8AR6ZO1.jpg","dateLastActive":"2023-09-22T20:39:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":144966,"lastUser":{"userID":144966,"name":"kelceyg","title":"Associate Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/kelceyg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QOWM4DMFF87J\/n3NJCD8AR6ZO1.jpg","dateLastActive":"2023-09-22T20:39:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":42,"score":null,"hot":3390638030,"url":"https:\/\/community.smartsheet.com\/discussion\/110591\/invalid-data-type-error-in-single-cell-of-column-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110591\/invalid-data-type-error-in-single-cell-of-column-formula","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/14XWFKFS2BZO\/sheet.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"sheet.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-21T19:02:19+00:00","dateAnswered":"2023-09-21T17:17:11+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":210,"urlcode":"human-resources","name":"Human Resources"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":84774,"type":"discussion","name":"INDEX and MATCH across two sheets: a detailed explanation","excerpt":"Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to easily utilize INDEX and MATCH functions to reference cells from another sheet by…","categoryID":338,"dateInserted":"2021-11-08T22:32:32+00:00","dateUpdated":"2023-09-12T19:51:46+00:00","dateLastComment":"2023-09-20T20:42:57+00:00","insertUserID":120297,"insertUser":{"userID":120297,"name":"Brett Wyrick","title":"Solution Architect","url":"https:\/\/community.smartsheet.com\/profile\/Brett%20Wyrick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G0J454DHMOIP\/n57O99FWK2XDE.png","dateLastActive":"2023-09-20T21:00:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":155003,"lastUser":{"userID":155003,"name":"Nick Stamatakis","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Stamatakis","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-wkld-_8Hzs!BYsowYeqM_s!mTUulD26odF","dateLastActive":"2023-09-28T20:06:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":53,"countViews":27640,"score":10,"hot":3331688129,"url":"https:\/\/community.smartsheet.com\/discussion\/84774\/index-and-match-across-two-sheets-a-detailed-explanation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84774\/index-and-match-across-two-sheets-a-detailed-explanation","format":"Rich","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":338,"name":"Best Practice","url":"https:\/\/community.smartsheet.com\/categories\/best-practices","allowedDiscussionTypes":["discussion","poll","question"]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":110515,"type":"question","name":"How do I add text to a formula","excerpt":"My current formula below works, and returns the value, 25%. But I want to add specific text to the value returned. So it should read, 25% - Milestone 1, or Milestone 1 - 25% =INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0)) Thanks.","categoryID":321,"dateInserted":"2023-09-20T16:52:32+00:00","dateUpdated":null,"dateLastComment":"2023-09-20T17:33:32+00:00","insertUserID":159073,"insertUser":{"userID":159073,"name":"SJTA","url":"https:\/\/community.smartsheet.com\/profile\/SJTA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-27T17:45:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":159073,"lastUser":{"userID":159073,"name":"SJTA","url":"https:\/\/community.smartsheet.com\/profile\/SJTA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-27T17:45:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":59,"score":null,"hot":3390461164,"url":"https:\/\/community.smartsheet.com\/discussion\/110515\/how-do-i-add-text-to-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110515\/how-do-i-add-text-to-a-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-20T17:32:18+00:00","dateAnswered":"2023-09-20T17:27:12+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":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":110498,"type":"idea","name":"Change \"end date\" based on status changes","excerpt":"When an end date is used in a dependency setting, you can't use automation or formulas to change it. However, this is when it is critical (pun fully intended)! When someone marks an item as Completed status, it would be helpful if the sheet could update the End Date column to the date it marked completed. For dependencies…","categoryID":349,"dateInserted":"2023-09-20T13:36:34+00:00","dateUpdated":null,"dateLastComment":"2023-09-20T15:05:13+00:00","insertUserID":128817,"insertUser":{"userID":128817,"name":"Amber Eakin","title":"Instructional Librarian","url":"https:\/\/community.smartsheet.com\/profile\/Amber%20Eakin","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BWFRATSm6no!!36C8hitfthg","dateLastActive":"2023-09-28T15:57:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":165946,"lastUser":{"userID":165946,"name":"Ksephora","url":"https:\/\/community.smartsheet.com\/profile\/Ksephora","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5zlweedaYsM!ApHz348Ou3M!e8_AAC1GSsa","dateLastActive":"2023-09-21T16:47:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":38,"score":3,"hot":3390440807,"url":"https:\/\/community.smartsheet.com\/discussion\/110498\/change-end-date-based-on-status-changes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110498\/change-end-date-based-on-status-changes","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":96663,"type":"idea","name":"Add 'sort order' to Filter Views","excerpt":"I love the Filter Views feature in Smartsheet, but it would be really useful to include Sorting options in the Filter View dialog as well. Some of my filter views require sorting by different columns, and currently it's a bit annoying have to manual sort each time I change a view.","categoryID":349,"dateInserted":"2022-10-17T13:30:36+00:00","dateUpdated":"2023-07-27T13:06:04+00:00","dateLastComment":"2023-09-19T17:37:14+00:00","insertUserID":137826,"insertUser":{"userID":137826,"name":"JPJPJP","title":"","url":"https:\/\/community.smartsheet.com\/profile\/JPJPJP","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtf_QJn03mwCbc0s7vf_cz0Vw4Dl8g2HkIz5wIKsx4cC=s96-c","dateLastActive":"2023-08-09T22:23:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":166796,"lastUser":{"userID":166796,"name":"Phillip Stringer","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Phillip%20Stringer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-19T17:33:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":773,"score":78,"hot":3361188470,"url":"https:\/\/community.smartsheet.com\/discussion\/96663\/add-sort-order-to-filter-views","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96663\/add-sort-order-to-filter-views","format":"Rich","groupID":null,"statusID":10003,"attributes":{"idea":{"statusNotes":"We agree this would be a really valuable capability. While we don't have a timeframe we can communicate right now, we can say that we are working on supporting sorting while filtered and also the ability to save that state for quick access and sharing.","statusID":10003,"status":{"name":"On Roadmap","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":366,"urlcode":"On Roadmap","name":"On Roadmap"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":49311,"type":"discussion","name":"Find First Duplicate in a Sheet","excerpt":"I am trying to find the first duplicate value with the purpose of using that to highlight another cell; however, my attempts at the first part of the process have resulted in both #UNPARSEABLE and #INVALID COLUMN VALUE. The formula I'm trying to use mimics something I've used successfully in Excel: =COUNTIF($[Master…","categoryID":322,"dateInserted":"2019-05-29T14:47:03+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-09-19T10:08:26+00:00","insertUserID":78276,"insertUser":{"userID":78276,"name":"Andrew Brimer","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20Brimer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T17:35:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":166744,"lastUser":{"userID":166744,"name":"carlne","title":"carlne","url":"https:\/\/community.smartsheet.com\/profile\/carlne","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ACg8ocIXruPlvBYy_rx0aWnukALSGSUXYsAYwAJlaP42ZuhB=s96-c","dateLastActive":"2023-09-26T09:38:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":13,"countViews":1023,"score":null,"hot":3254267129,"url":"https:\/\/community.smartsheet.com\/discussion\/49311\/find-first-duplicate-in-a-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49311\/find-first-duplicate-in-a-sheet","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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"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":95370,"type":"idea","name":"Group Columns in Grid","excerpt":"Hi! I use a really large grid-style Smartsheet to track all aspects of project development and health. It would be very helpful to have a way of grouping columns. The hierarchy for rows works great, but I think with columns I am just looking for a way to clean up my views. I feel like the best (and only) solution right now…","categoryID":349,"dateInserted":"2022-09-14T20:17:00+00:00","dateUpdated":"2023-09-05T11:34:48+00:00","dateLastComment":"2023-09-18T22:16:50+00:00","insertUserID":113894,"insertUser":{"userID":113894,"name":"Laura Payne","url":"https:\/\/community.smartsheet.com\/profile\/Laura%20Payne","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hdlbITHk9Tw!xnta8eHpOzQ!cFhmjtLaehI","dateLastActive":"2023-08-14T18:32:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":158303,"lastUser":{"userID":158303,"name":"RobH","url":"https:\/\/community.smartsheet.com\/profile\/RobH","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-22T03:43:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":18,"countViews":854,"score":54,"hot":3358289030,"url":"https:\/\/community.smartsheet.com\/discussion\/95370\/group-columns-in-grid","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95370\/group-columns-in-grid","format":"Rich","groupID":null,"statusID":10004,"attributes":{"idea":{"statusNotes":"We agree this would be a great improvement organizing and navigating large, complex sheets. This is definitely on our mind and something we are exploring for the future. Please up vote and add example use cases or details as you have them.","statusID":10004,"status":{"name":"On Wishlist","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":367,"urlcode":"On Wishlist","name":"On Wishlist"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":110356,"type":"question","name":"How do you set up a project timeline to work around set meeting dates?","excerpt":"I am putting together a sheet \/ gantt chart for a project. My project needs to be approved by several committees as it progresses through various stages. These committees have fixed meeting dates that are scheduled out a year in advance and only happen once per month. Is there a way to program the currently scheduled…","categoryID":321,"dateInserted":"2023-09-15T19:52:55+00:00","dateUpdated":"2023-09-15T20:24:39+00:00","dateLastComment":"2023-09-17T06:03:30+00:00","insertUserID":166638,"insertUser":{"userID":166638,"name":"LButton","url":"https:\/\/community.smartsheet.com\/profile\/LButton","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-18T12:47:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":165246,"lastUser":{"userID":165246,"name":"Tim C","title":"Employee","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20C","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtfibCxrjhNshWbd7_gC3ivkN_Xum8yi8EqsTXnd1Wn_ig=s96-c","dateLastActive":"2023-09-28T14:31:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":44,"score":null,"hot":3389738785,"url":"https:\/\/community.smartsheet.com\/discussion\/110356\/how-do-you-set-up-a-project-timeline-to-work-around-set-meeting-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110356\/how-do-you-set-up-a-project-timeline-to-work-around-set-meeting-dates","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-09-17T06:03:30+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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt 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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">