公式

[Start 2020]2; Today2 < [End2020]2); NETWORKDAYS([Start 2020]2; [End 2020]2) -…","categoryID":322,"dateInserted":"2019-04-03T10:17:04+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-05T13:34:52+00:00","insertUserID":7439,"insertUser":{"userID":7439,"name":"Trym Dahl","url":"https:\/\/community.smartsheet.com\/profile\/Trym%20Dahl","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-08T07:47:50+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-12T03:09:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":137,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/44956\/formula-unparsable","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/44956\/formula-unparsable","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":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":45091,"type":"discussion","name":"Checkbox If Formula","excerpt":"Wondering if this is possible: I am trying to create an IF formula in a checkbox column where, based on the Start Date of one of the rows, if the date is in the future, it will not be checked, but if the date is today or in the past, it will be checked. I was playing around with the below formula but it was not working.…","categoryID":322,"dateInserted":"2019-04-04T16:21:20+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-05T13:01:48+00:00","insertUserID":84261,"insertUser":{"userID":84261,"name":"kleinsb","url":"https:\/\/community.smartsheet.com\/profile\/kleinsb","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wjFZd_WKOHo!!3cFXbDsuqpl","dateLastActive":"2020-11-18T20:35:34+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-12T03:09:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":117,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/45091\/checkbox-if-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45091\/checkbox-if-formula","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":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":45111,"type":"discussion","name":"Total cost to previous Wednesday","excerpt":"Hi everyone, I have a question and hope someone can help me with this. If I have a new task & I want to get the total cost until the previous Wednesday, is there any formula that I can use in Smartsheet? For example, if I open the file today, it will show the total from the start date to April 3rd. Thank you.","categoryID":322,"dateInserted":"2019-04-04T21:59:15+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-05T12:49:14+00:00","insertUserID":84126,"insertUser":{"userID":84126,"name":"Indi","url":"https:\/\/community.smartsheet.com\/profile\/Indi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-09T05:40:29+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-12T03:09:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":55,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/45111\/total-cost-to-previous-wednesday","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45111\/total-cost-to-previous-wednesday","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":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":34671,"type":"discussion","name":"Count values in a column or Pivot table","excerpt":"Hello, I don't have a pivot table app so I am looking for formula help. I have a grid that has a column called \"Goal\". Users and choose a value from the drop down or type in their own value in this field. I need to be able to generate a pie chart that shows the number of times each value shows up in that field. For…","categoryID":322,"dateInserted":"2018-10-27T15:46:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-05T12:15:01+00:00","insertUserID":49111,"insertUser":{"userID":49111,"name":"cyndi2403","url":"https:\/\/community.smartsheet.com\/profile\/cyndi2403","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-10\/ab\/68\/nab68f20c160a0a7640e21679392cded3.jpg","dateLastActive":"2020-09-12T13:31:05+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-12T08:26:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":727,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/34671\/count-values-in-a-column-or-pivot-table","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/34671\/count-values-in-a-column-or-pivot-table","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":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":45136,"type":"discussion","name":"Countifs Multi-select Contact","excerpt":"Hi Everyone, I have a sheet that contains a list of projects. In the sheet I have a column that is setup as a contact column and allows multiple contacts (Project Managers) and a column for project state (State). In my statistic sheet I list all of my project managers(ITPMO ProjectManager) and I want to look back into the…","categoryID":322,"dateInserted":"2019-04-05T11:15:14+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-05T11:47:20+00:00","insertUserID":84421,"insertUser":{"userID":84421,"name":"aclay","url":"https:\/\/community.smartsheet.com\/profile\/aclay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-05-05T17:11:32+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-12T08:26:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":487,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/45136\/countifs-multi-select-contact","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45136\/countifs-multi-select-contact","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":234,"urlcode":"Health-care","name":"Healthcare"},{"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":44926,"type":"discussion","name":"COUNTIFS a range with multiple assigned groups","excerpt":"Hello all, I am trying to COUNTIF a range that includes multiple assigned groups in some cells. I would like to count rows that include \"Dept 1\". There is one row in particular that contains two assigned groups - \"Dept 1\" and \"Dept 2\" - that is not being counted This is my formula: =COUNTIF({Sheet Range 4 - Department},…","categoryID":322,"dateInserted":"2019-04-03T08:51:11+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-05T08:37:28+00:00","insertUserID":84011,"insertUser":{"userID":84011,"name":"pixel_","url":"https:\/\/community.smartsheet.com\/profile\/pixel_","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-03-26T18:41:48+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-12T03:09:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":87,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/44926\/countifs-a-range-with-multiple-assigned-groups","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/44926\/countifs-a-range-with-multiple-assigned-groups","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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"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":16301,"type":"discussion","name":"Just want the checkbox to check if the date is past due","excerpt":"Hi All, I've got a basic spreadsheet that I need the have the \"complete\" box automatically check itself if the due date is 1 day past due. I know I can do this with an =IF formula, I just can't figure out how. Can someone help? Best!","categoryID":319,"dateInserted":"2017-11-28T12:38:51+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-05T02:29:04+00:00","insertUserID":30961,"insertUser":{"userID":30961,"name":"ASalmon","url":"https:\/\/community.smartsheet.com\/profile\/ASalmon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-11-28T12:37:30+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-12T08:26:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":863,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/16301\/just-want-the-checkbox-to-check-if-the-date-is-past-due","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16301\/just-want-the-checkbox-to-check-if-the-date-is-past-due","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"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":45076,"type":"discussion","name":"Return the NETWORKDAYS of 1 month of a 2-month duration","excerpt":"The goal is to count the number of days that an Employee is not assigned work within a given month (MONTH A, MONTH B, etc). For example, a given month has 23 working days; I could use NETWORKDAYS of the duration to count the assigned days of that Task; say 19. To reach my goal, I would simply subract the NETWORKDAYS from…","categoryID":322,"dateInserted":"2019-04-04T15:12:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-04T16:25:50+00:00","insertUserID":49351,"insertUser":{"userID":49351,"name":"Dan Seidler","url":"https:\/\/community.smartsheet.com\/profile\/Dan%20Seidler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-01-05T21:53:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T13:58:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":126,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/45076\/return-the-networkdays-of-1-month-of-a-2-month-duration","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45076\/return-the-networkdays-of-1-month-of-a-2-month-duration","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"}],"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":45061,"type":"discussion","name":"Formula Needed for Parent to Inherit Child Value","excerpt":"I don't think this is possible, but I need a formula where a parent row Status value reads \"No Active Projects\" until it has a child row below it with an \"In Progress\" status at which point the cell should just be blank. See image below. I use the \"No Active Projects\" marker to determine whether or not that department…","categoryID":322,"dateInserted":"2019-04-04T12:17:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-04T16:25:17+00:00","insertUserID":10742,"insertUser":{"userID":10742,"name":"Lauren B","url":"https:\/\/community.smartsheet.com\/profile\/Lauren%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/eb\/a5\/neba5744ddf2b6f504378c4783d9ce90f.jpg","dateLastActive":"2019-04-04T12:11:48+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-12T08:26:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":280,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/45061\/formula-needed-for-parent-to-inherit-child-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45061\/formula-needed-for-parent-to-inherit-child-value","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-04\/a2\/e4\/a2e4996e88e364b71f6457f92ef54430.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"SS Status Formula Example.PNG"},"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":274,"urlcode":"Legal","name":"Legal"},{"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}]},{"discussionID":44556,"type":"discussion","name":"Unique list of values w\/ VLOOKUP or INDEX\/MATCH not working","excerpt":"I am trying to use the aforementioned functions to crate a list of unique values by referencing a separate sheet. The source sheet contains a column of date values and a column of checkboxes which indicate unique dates. using either functions indicates #NO MATCHES which is incorrect. Please let me know how to make this…","categoryID":322,"dateInserted":"2019-03-27T16:36:11+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-04T15:44:58+00:00","insertUserID":83431,"insertUser":{"userID":83431,"name":"underscore_","url":"https:\/\/community.smartsheet.com\/profile\/underscore_","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-08T09:39:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45236,"lastUser":{"userID":45236,"name":"Alejandra","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Alejandra","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-04\/8a\/fe\/n8afeceb592ad5845f46c7d931defba07.JPG","dateLastActive":"2020-05-15T18:56:51+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":158,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/44556\/unique-list-of-values-w-vlookup-or-index-match-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/44556\/unique-list-of-values-w-vlookup-or-index-match-not-working","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-03\/d9\/bd\/d9bd61e044e642c582d892f41afb2c36.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"VLOOKUP.JPG"},"attributes":{},"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"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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}">