Formulas and Functions

Исполнитель4); ([Стоимость работы (с НДФЛ) (из первичной)]4 < [Cтоимость работы (с НДФЛ)]4));\"ДА\";\"НЕТ\") Thank you in advance.","categoryID":322,"dateInserted":"2020-08-06T08:59:49+00:00","dateUpdated":null,"dateLastComment":"2020-08-13T08:12:12+00:00","insertUserID":124726,"insertUser":{"userID":124726,"name":"Anna Pelipas","url":"https:\/\/community.smartsheet.com\/profile\/Anna%20Pelipas","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!W0jQHwhWWLQ!BAvXQT9O6b4!BMOnIoQ3nTF","dateLastActive":"2020-09-01T19:09:09+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-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":13,"countViews":81,"score":null,"hot":13,"url":"https:\/\/community.smartsheet.com\/discussion\/70411\/if-formula-doesnt-work","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70411\/if-formula-doesnt-work","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":70551,"type":"question","name":"Two dates between Now and +7 Days","excerpt":"Hi I am trying to return a count of dates between two dates that will move based on todays date, I have tried umpteen different approaches but cannot get the sheet to return a valid answer. =COUNTIF(MigrationDate1:MigrationDate3, >TODAY() <= TODAY(+7)) 19\/08\/20 19\/08\/20 05\/08\/20 The answer it returns is 3. I would have…","categoryID":322,"dateInserted":"2020-08-12T16:59:10+00:00","dateUpdated":null,"dateLastComment":"2020-08-13T08:00:52+00:00","insertUserID":7053,"insertUser":{"userID":7053,"name":"Colin Whelan","url":"https:\/\/community.smartsheet.com\/profile\/Colin%20Whelan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-01T14:28:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":7053,"lastUser":{"userID":7053,"name":"Colin Whelan","url":"https:\/\/community.smartsheet.com\/profile\/Colin%20Whelan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-01T14:28:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":83,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/70551\/two-dates-between-now-and-7-days","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70551\/two-dates-between-now-and-7-days","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-13T08:00:11+00:00","dateAnswered":"2020-08-12T18:28: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":[],"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":70572,"type":"question","name":"Have a different email UI than what's in the request an update form","excerpt":"Hello - I am sending out pretty lengthly update request logic emails. I was wondering if there was a way that when the person receives an email they see only a few columns, but when they click the link to update the form, all of the columns appear. For example - I'm sending out an update request with about 24 columns. So…","categoryID":322,"dateInserted":"2020-08-13T01:35:44+00:00","dateUpdated":null,"dateLastComment":"2020-08-13T07:05:56+00:00","insertUserID":125132,"insertUser":{"userID":125132,"name":"Jamie Kalff","url":"https:\/\/community.smartsheet.com\/profile\/Jamie%20Kalff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-13T01:32:22+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-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":62,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/70572\/have-a-different-email-ui-than-whats-in-the-request-an-update-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70572\/have-a-different-email-ui-than-whats-in-the-request-an-update-form","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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":70537,"type":"question","name":"Does Smartsheet allow the calculation of IRR?","excerpt":"I have found a key element of Program Management that needs solution in the Smartsheet platform. The calculation for IRR is critical component and not available as general function. As you may know, this simple one varying net cash flow typical program. Does anyone calculating real-life program can share with me?.","categoryID":322,"dateInserted":"2020-08-12T11:13:24+00:00","dateUpdated":null,"dateLastComment":"2020-08-13T01:58:41+00:00","insertUserID":125095,"insertUser":{"userID":125095,"name":"Michael Mather","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Mather","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!X-fXX38yfj4!pRDXaUs6r1Q!GGA-t2nDpaH","dateLastActive":"2021-04-19T16:57:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":125095,"lastUser":{"userID":125095,"name":"Michael Mather","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Mather","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!X-fXX38yfj4!pRDXaUs6r1Q!GGA-t2nDpaH","dateLastActive":"2021-04-19T16:57:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":601,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/70537\/does-smartsheet-allow-the-calculation-of-irr","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70537\/does-smartsheet-allow-the-calculation-of-irr","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-12T17:58:42+00:00","dateAnswered":"2020-08-12T16:10: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":238,"urlcode":"finance","name":"Finance"},{"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":70541,"type":"question","name":"INDEX & MATCH where the MATCH is based on a multi select dropdown?","excerpt":"Hi - I have been trying to work this out, read through a number of threads, but, cant see this question directly answered. Scenario: I have 1 sheet that has a list of tools and another sheet which is used to record who those tools have been handed out to by using a multi select dropsown column. What I would like to be able…","categoryID":322,"dateInserted":"2020-08-12T13:41:03+00:00","dateUpdated":"2020-08-12T13:49:24+00:00","dateLastComment":"2020-08-12T22:37:56+00:00","insertUserID":59916,"insertUser":{"userID":59916,"name":"sean59916","title":"","url":"https:\/\/community.smartsheet.com\/profile\/sean59916","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-08\/b1\/43\/nb14312faa18c300e84f0ec627a78ccc7.jpg","dateLastActive":"2021-02-20T01:58:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":59916,"lastUserID":59916,"lastUser":{"userID":59916,"name":"sean59916","title":"","url":"https:\/\/community.smartsheet.com\/profile\/sean59916","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-08\/b1\/43\/nb14312faa18c300e84f0ec627a78ccc7.jpg","dateLastActive":"2021-02-20T01:58:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":502,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/70541\/index-match-where-the-match-is-based-on-a-multi-select-dropdown","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70541\/index-match-where-the-match-is-based-on-a-multi-select-dropdown","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/1Q50DBJ10F0L\/tool-list.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"tool_list.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-12T22:38:46+00:00","dateAnswered":"2020-08-12T21:41:04+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":[],"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":70560,"type":"question","name":"=Count(children()) of multiple parent rows.","excerpt":"I'm trying to count the contents of multiple children in different cells for a grand total. I've organized my information by the media outlet, which will count its children for an \"at a glance\" total for ease of use. I would like the parent cell (\"2 open inquiries\") to count all the children for a total of all open…","categoryID":322,"dateInserted":"2020-08-12T21:07:16+00:00","dateUpdated":null,"dateLastComment":"2020-08-12T21:52:58+00:00","insertUserID":125122,"insertUser":{"userID":125122,"name":"Sarah Zimmerman","url":"https:\/\/community.smartsheet.com\/profile\/Sarah%20Zimmerman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-19T13:21:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":125122,"lastUser":{"userID":125122,"name":"Sarah Zimmerman","url":"https:\/\/community.smartsheet.com\/profile\/Sarah%20Zimmerman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-19T13:21:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":83,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/70560\/count-children-of-multiple-parent-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70560\/count-children-of-multiple-parent-rows","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/IPFRPDGC42UG\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":70556,"type":"question","name":"Auto Assign Contact Based on another column's content","excerpt":"Hello, I would like help with creating a formula to auto assign someone to a row based on who was originally selected. In this example, I want to manually assign an officer and have the Team Lead & Front Office Support to auto populate answers based on who was selected as an officer. Both Team Lead & Front Office Support…","categoryID":322,"dateInserted":"2020-08-12T19:42:46+00:00","dateUpdated":null,"dateLastComment":"2020-08-12T20:30:06+00:00","insertUserID":122774,"insertUser":{"userID":122774,"name":"Mallory McFall","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mallory%20McFall","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bbPD2z0YVvw!0ujCv-kldiY!Y3o_62EPxu8","dateLastActive":"2021-08-13T15:45:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":115578,"lastUser":{"userID":115578,"name":"David Joyeuse","url":"https:\/\/community.smartsheet.com\/profile\/David%20Joyeuse","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2021-08-19T14:05:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":476,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/70556\/auto-assign-contact-based-on-another-columns-content","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70556\/auto-assign-contact-based-on-another-columns-content","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/JXOYSYXZSW1W\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":70516,"type":"question","name":"How do I display a Max Date for Child Tasks only if there are no blank Children?","excerpt":"I have a sheet with many hierarchies of Parent and Child Tasks. I want to display the Max Date of the Children, but only when there are not any blank values for the Children. Objective 1 - Completion Date 8\/10\/20 • Task A - Completion Date 8\/7\/20 • Task B - Completion Date 8\/10\/20 Objective 2 - Completion Date TBD or blank…","categoryID":322,"dateInserted":"2020-08-11T16:56:07+00:00","dateUpdated":null,"dateLastComment":"2020-08-12T20:23:01+00:00","insertUserID":121055,"insertUser":{"userID":121055,"name":"Jake Gustafson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jake%20Gustafson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-lnW91tuGTw!bO9UmyNQSXQ!WUYBUm0HF6t","dateLastActive":"2023-08-25T12:53:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":121055,"lastUser":{"userID":121055,"name":"Jake Gustafson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jake%20Gustafson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-lnW91tuGTw!bO9UmyNQSXQ!WUYBUm0HF6t","dateLastActive":"2023-08-25T12:53:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":816,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/70516\/how-do-i-display-a-max-date-for-child-tasks-only-if-there-are-no-blank-children","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70516\/how-do-i-display-a-max-date-for-child-tasks-only-if-there-are-no-blank-children","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":70462,"type":"question","name":"Count completed dates once from two columns counting only the most recent competion date by week","excerpt":"I'm trying to count the number of quotes completed by week. The challenge is there are two departments who may work on a quote and each enter their own completion date. Sometimes only one department works on a quote so only one of the two completion date columns is filled in. In a nutshell I want to only count \"Type A\"…","categoryID":322,"dateInserted":"2020-08-07T19:41:18+00:00","dateUpdated":null,"dateLastComment":"2020-08-12T20:19:42+00:00","insertUserID":124975,"insertUser":{"userID":124975,"name":"Lynn Strahm","url":"https:\/\/community.smartsheet.com\/profile\/Lynn%20Strahm","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-11T22:42:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":124975,"lastUser":{"userID":124975,"name":"Lynn Strahm","url":"https:\/\/community.smartsheet.com\/profile\/Lynn%20Strahm","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-11T22:42:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":63,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/70462\/count-completed-dates-once-from-two-columns-counting-only-the-most-recent-competion-date-by-week","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70462\/count-completed-dates-once-from-two-columns-counting-only-the-most-recent-competion-date-by-week","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-13T09:19:26+00:00","dateAnswered":"2020-08-07T19:53:34+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":[],"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":70315,"type":"question","name":"Can Index Match pull multiple records?","excerpt":"I am trying to pull contract numbers from an Active Contract file over to a 2nd file using the customer name as the unique identifier which is working just fine via INDEX(MATCH), however, if a customer has more than 1 active contract it only pulls the first one over. What's the best way to pull all of the contract numbers…","categoryID":322,"dateInserted":"2020-08-03T15:19:00+00:00","dateUpdated":null,"dateLastComment":"2020-08-12T17:03:43+00:00","insertUserID":123811,"insertUser":{"userID":123811,"name":"Lexie Ozolnieks","url":"https:\/\/community.smartsheet.com\/profile\/Lexie%20Ozolnieks","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-12T17:01:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":123811,"lastUser":{"userID":123811,"name":"Lexie Ozolnieks","url":"https:\/\/community.smartsheet.com\/profile\/Lexie%20Ozolnieks","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-12T17:01:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":62,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/70315\/can-index-match-pull-multiple-records","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70315\/can-index-match-pull-multiple-records","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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"}],"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}">

Help Article Resources