表

1), 1, 0) that checks all the indexkeys in the column to see if there are any duplicates. This works perfectly on my tester sheet which is an exact copy of the sheet I want the formula on but for some reason doesn't work on the main sheet and returns 0…","categoryID":321,"dateInserted":"2023-02-17T09:43:40+00:00","dateUpdated":null,"dateLastComment":"2023-02-17T09:45:15+00:00","insertUserID":156778,"insertUser":{"userID":156778,"name":"ross chambers","url":"https:\/\/community.smartsheet.com\/profile\/ross%20chambers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-19T08:56:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":156778,"lastUser":{"userID":156778,"name":"ross chambers","url":"https:\/\/community.smartsheet.com\/profile\/ross%20chambers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-19T08:56:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":60,"score":null,"hot":3353254735,"url":"https:\/\/community.smartsheet.com\/discussion\/101327\/formula-work-one-one-sheet-but-not-another","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101327\/formula-work-one-one-sheet-but-not-another","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-17T09:45:23+00:00","dateAnswered":"2023-02-17T09:45:15+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":65583,"type":"question","name":"Formula to check box if cell contains Date OR Text","excerpt":"I have a nested formula that currently involves one check box be checked and three date columns to contain dates in order to check-mark as 'Complete.' However, I discovered one of the date columns involved may contain text from time to time (as a date is not always applicable to this particular field). How can I revise my…","categoryID":321,"dateInserted":"2020-01-28T22:34:19+00:00","dateUpdated":null,"dateLastComment":"2023-02-16T20:22:01+00:00","insertUserID":114831,"insertUser":{"userID":114831,"name":"Melissa Shandy","url":"https:\/\/community.smartsheet.com\/profile\/Melissa%20Shandy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!kpNCvxUSffw!HaFE3_cvl_o!MSnQcMpysii","dateLastActive":"2023-04-24T19:19:46+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-06-15T21:50:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":15480,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/65583\/formula-to-check-box-if-cell-contains-date-or-text","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65583\/formula-to-check-box-if-cell-contains-date-or-text","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/842\/0RJLZ49L42I3.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"File Sample.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-01-29T17:55:11+00:00","dateAnswered":"2020-01-29T08:58: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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":101251,"type":"question","name":"Creating a survey & collecting feedback for a list of submissions","excerpt":"I've created an intake form and sheet to collect project request submissions, and now need to create a way for the project committee (8 members) to score each submission using a simple 4 value Impact\/Effort score that I'd like to present in a Survey Form so I can collect the data and consolidate for presentation on…","categoryID":321,"dateInserted":"2023-02-16T13:36:40+00:00","dateUpdated":null,"dateLastComment":"2023-02-16T14:20:14+00:00","insertUserID":155860,"insertUser":{"userID":155860,"name":"eric.wong.compass","url":"https:\/\/community.smartsheet.com\/profile\/eric.wong.compass","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-16T14:20:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":139776,"lastUser":{"userID":139776,"name":"Ipshita","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ipshita","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/F9QTGWYO7ON4\/n1235F4AIWZTU.JPG","dateLastActive":"2023-06-14T06:49:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":91,"score":null,"hot":3353114214,"url":"https:\/\/community.smartsheet.com\/discussion\/101251\/creating-a-survey-collecting-feedback-for-a-list-of-submissions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101251\/creating-a-survey-collecting-feedback-for-a-list-of-submissions","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-16T13:52:51+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":204,"urlcode":"Forms","name":"Forms"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":335,"urlcode":"sheet-summary","name":"Sheet Summary"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":417,"urlcode":"survey","name":"survey"}],"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":97294,"type":"discussion","name":"Reports and Sheets limited to printing 100 images only","excerpt":"One of the team has asked about printing to PDF a Sheet that contains more than 100 images embedded in the Sheet (not attachments). When attempting to print, only the first 100 lines of data is displayed. Has anyone worked out how to overcome this? (I don't want to have to separate PDF's.)","categoryID":321,"dateInserted":"2022-11-02T23:33:59+00:00","dateUpdated":null,"dateLastComment":"2023-02-15T20:25:48+00:00","insertUserID":87801,"insertUser":{"userID":87801,"name":"Richard Heath","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Richard%20Heath","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/PQ5MK3GA3T0T\/nRH0VLM6IQ91L.jpg","dateLastActive":"2023-06-20T03:51:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":158348,"lastUser":{"userID":158348,"name":"TrisRowe","url":"https:\/\/community.smartsheet.com\/profile\/TrisRowe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-15T20:23:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":168,"score":null,"hot":3343925987,"url":"https:\/\/community.smartsheet.com\/discussion\/97294\/reports-and-sheets-limited-to-printing-100-images-only","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97294\/reports-and-sheets-limited-to-printing-100-images-only","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/LUP4IA8TN05J\/screenshot-2022-11-03-100050.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2022-11-03 100050.jpg"},"attributes":{},"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":250,"urlcode":"Printing","name":"Printing"},{"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":101169,"type":"question","name":"Nested IF Statement with OR and AND functions","excerpt":"Hello, I am trying to create a nested IF statement. The formula is fed by two columns Status and End Date. The formula should return that IF status is one of \"Completed\" or \"Adoption\/Sustain\" AND the end date column has a date (any date) then return \"Yes\" if true. I keep getting Unparseable or Circular Reference errors.…","categoryID":322,"dateInserted":"2023-02-15T15:39:06+00:00","dateUpdated":null,"dateLastComment":"2023-02-15T20:03:16+00:00","insertUserID":158323,"insertUser":{"userID":158323,"name":"ksabrin","url":"https:\/\/community.smartsheet.com\/profile\/ksabrin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-17T15:49:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":126800,"lastUser":{"userID":126800,"name":"Kelly P.","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T14:42:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":58,"score":null,"hot":3352967542,"url":"https:\/\/community.smartsheet.com\/discussion\/101169\/nested-if-statement-with-or-and-and-functions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101169\/nested-if-statement-with-or-and-and-functions","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-15T20:03:16+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":101118,"type":"question","name":"INDEX\/Match Error?","excerpt":"Hello, I have the following Equation written out: =INDEX({Brand Manager}, MATCH([Brand Channel]@row, {Brand Channel}), 0) {Brand Manager} and {Brand Channel} are pulling from Sheet A. Brand Channel is a column that is in Sheet A and Sheet B. The equation is written in Sheet B. My expectation of the equation was to pull in…","categoryID":322,"dateInserted":"2023-02-14T18:25:58+00:00","dateUpdated":null,"dateLastComment":"2023-02-15T11:56:52+00:00","insertUserID":153102,"insertUser":{"userID":153102,"name":"ChaunyT","url":"https:\/\/community.smartsheet.com\/profile\/ChaunyT","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-13T18:55:31+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-06-20T10:05:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":60,"score":null,"hot":3352862570,"url":"https:\/\/community.smartsheet.com\/discussion\/101118\/index-match-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101118\/index-match-error","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-14T19:11:15+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"},{"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":101107,"type":"question","name":"move workflow stopped because of system column","excerpt":"Hello I have 2 sheets a master sheet and a sheet that is populated from a form. the first few columns on the master sheet are filled in via form, that data is then used for estimation which is filled into the second form. the data from the first form is added to the data from the second form on the second sheet using…","categoryID":321,"dateInserted":"2023-02-14T16:39:40+00:00","dateUpdated":null,"dateLastComment":"2023-02-15T10:08:31+00:00","insertUserID":156778,"insertUser":{"userID":156778,"name":"ross chambers","url":"https:\/\/community.smartsheet.com\/profile\/ross%20chambers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-19T08:56:16+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-06-20T09:30:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":83,"score":null,"hot":3352850291,"url":"https:\/\/community.smartsheet.com\/discussion\/101107\/move-workflow-stopped-because-of-system-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101107\/move-workflow-stopped-because-of-system-column","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-15T08:51:06+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":204,"urlcode":"Forms","name":"Forms"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}],"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":101134,"type":"question","name":"How to aggregate sheet summary data into another sheet","excerpt":"Hello, I am currently working on developing a workspace to track system testing. The way the workspace is currently set up is having a summary level sheet that has each script, and then a folder per script. Within each script specific folder, there is a script summary sheet and a test script sheet. There can be multiple…","categoryID":322,"dateInserted":"2023-02-14T19:49:22+00:00","dateUpdated":null,"dateLastComment":"2023-02-14T20:44:02+00:00","insertUserID":158289,"insertUser":{"userID":158289,"name":"slaranda","url":"https:\/\/community.smartsheet.com\/profile\/slaranda","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-14T20:45:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":139776,"lastUser":{"userID":139776,"name":"Ipshita","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ipshita","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/F9QTGWYO7ON4\/n1235F4AIWZTU.JPG","dateLastActive":"2023-06-14T06:49:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":93,"score":null,"hot":3352813404,"url":"https:\/\/community.smartsheet.com\/discussion\/101134\/how-to-aggregate-sheet-summary-data-into-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101134\/how-to-aggregate-sheet-summary-data-into-another-sheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-14T20:08:51+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":292,"urlcode":"Dashboards","name":"Dashboards"}],"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":101011,"type":"question","name":"Why doesn't INDEX(MATCH) work as intended?","excerpt":"Hi, all: I've recently been assigned to work on a set of tools for my team that have been run in Smartsheet for some time, and am really struggling. Setup: 4 sheets, for 4 separate project-cycle teams. Each sheet needs to refer to the same core set of unique IDs entered in the primary column for Sheet 1. All sheets contain…","categoryID":322,"dateInserted":"2023-02-10T21:57:42+00:00","dateUpdated":null,"dateLastComment":"2023-02-14T18:06:37+00:00","insertUserID":158176,"insertUser":{"userID":158176,"name":"ChristineNDI","url":"https:\/\/community.smartsheet.com\/profile\/ChristineNDI","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-13T16:34:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":158176,"lastUser":{"userID":158176,"name":"ChristineNDI","url":"https:\/\/community.smartsheet.com\/profile\/ChristineNDI","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-13T16:34:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":84,"score":null,"hot":3352466059,"url":"https:\/\/community.smartsheet.com\/discussion\/101011\/why-doesnt-index-match-work-as-intended","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101011\/why-doesnt-index-match-work-as-intended","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-13T13:23:36+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"},{"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":101054,"type":"question","name":"Keyboard shortcut to delete the selected row(s)?","excerpt":"Has this feature been added? Reviving an old thread from 2015 posted by Maxim Miller (see below) and I'd like to see if there's been an update: \"I can't find how to delete the selected row using keyboard. I can only do that using mouse. It's very inconvenient - in MS Project I select entire row using shift+space and press…","categoryID":321,"dateInserted":"2023-02-13T16:40:57+00:00","dateUpdated":null,"dateLastComment":"2023-02-14T15:55:30+00:00","insertUserID":158223,"insertUser":{"userID":158223,"name":"Fred Burki","url":"https:\/\/community.smartsheet.com\/profile\/Fred%20Burki","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uwDGZykcn2c!5yjEOS6HY6c!MQ8xujTw7n6","dateLastActive":"2023-04-14T21:45:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":158223,"lastUser":{"userID":158223,"name":"Fred Burki","url":"https:\/\/community.smartsheet.com\/profile\/Fred%20Burki","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uwDGZykcn2c!5yjEOS6HY6c!MQ8xujTw7n6","dateLastActive":"2023-04-14T21:45:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":89,"score":2,"hot":3352698387,"url":"https:\/\/community.smartsheet.com\/discussion\/101054\/keyboard-shortcut-to-delete-the-selected-row-s","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101054\/keyboard-shortcut-to-delete-the-selected-row-s","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-14T15:54:11+00:00","dateAnswered":"2023-02-14T14:04:55+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":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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">