法律

0 below is the formula I came up with, however it is not working. =IF(INDEX({Due Dates}, MATCH([Client Matter]2, {Client Matter #})), {Days Remaining}, @cell > 0) Also, is there a way to do an Index Match or vlook up that gives me the…","categoryID":322,"dateInserted":"2019-09-24T13:28:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-25T08:02:41+00:00","insertUserID":75766,"insertUser":{"userID":75766,"name":"Karrie Davis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Karrie%20Davis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QK72Y4JY5UIX\/n294YLQHLLQO2.jpg","dateLastActive":"2023-06-06T17:54:35+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"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-11T12:14:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":229,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/58456\/if-index-match","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/58456\/if-index-match","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-09\/0e\/06\/0e06342f4382aba1f0ba3f7ff3203c49.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"if INdex match.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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":274,"urlcode":"Legal","name":"Legal"},{"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":57311,"type":"discussion","name":"Nested Crtiteria","excerpt":"Hi, I'm trying to write a formula that would give me the total Number of request by person, that does not include Completed or abandoned. I used the following formula and it come up as nested criteria. =COUNTIFS({Status}, @cell <> $[Primary Column]7, {Owner}, @cell = \"Erica\" + COUNTIFS({Status}, @cell <> $[Primary…","categoryID":322,"dateInserted":"2019-09-09T17:10:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-10T14:41:13+00:00","insertUserID":75766,"insertUser":{"userID":75766,"name":"Karrie Davis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Karrie%20Davis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QK72Y4JY5UIX\/n294YLQHLLQO2.jpg","dateLastActive":"2023-06-06T17:54:35+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"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-11T12:14:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":503,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/57311\/nested-crtiteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/57311\/nested-crtiteria","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-09\/c8\/68\/c8683b562897a08f449397ce78846818.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"nested criteria.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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":274,"urlcode":"Legal","name":"Legal"},{"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":56996,"type":"discussion","name":"If Current Month","excerpt":"Hi I'm trying to write a formula that will show me a column for the current Month Currently formula =If(Month(date column)= 9, [Project]1)- This works and displays the correct cell, however I want the column to change with the month so I tried= IF(Month(date column)=Month(Today()), [Project]1), I get an error Any…","categoryID":322,"dateInserted":"2019-09-04T19:27:31+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-09T14:10:54+00:00","insertUserID":75766,"insertUser":{"userID":75766,"name":"Karrie Davis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Karrie%20Davis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QK72Y4JY5UIX\/n294YLQHLLQO2.jpg","dateLastActive":"2023-06-06T17:54:35+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"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-11T12:14:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":326,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/56996\/if-current-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/56996\/if-current-month","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":274,"urlcode":"Legal","name":"Legal"},{"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":55836,"type":"discussion","name":"Assigning Multiple Tasks to an Entire Team","excerpt":"Hi I am new to Smartsheet, and hence am unable to perform the subject activity in it. I have a set of 25 tasks called \"Proofreading Tasks\". And I have around 15 people in a team which is called \"Team - Proofreaders\" . This team is supposed to perform these -- and only these -- tasks. Now how do I set it up in Smartsheet so…","categoryID":321,"dateInserted":"2019-08-22T01:01:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-23T05:19:23+00:00","insertUserID":101121,"insertUser":{"userID":101121,"name":"Nasir@EBC","url":"https:\/\/community.smartsheet.com\/profile\/Nasir%40EBC","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!BXjVgasCKqQ!c2DUpw9M-nY!rKVmGGpiJ0x","dateLastActive":"2023-03-08T10:45: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-06-11T18:18:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":116,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/55836\/assigning-multiple-tasks-to-an-entire-team","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/55836\/assigning-multiple-tasks-to-an-entire-team","format":"Html","groupID":null,"statusID":0,"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":247,"urlcode":"Contacts","name":"Contacts"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":274,"urlcode":"Legal","name":"Legal"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group 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":55531,"type":"discussion","name":"Archiving - Not Using Control Center","excerpt":"Some of our projects go on for a very long time. Each group has their own list of projects. We add status notes in the Comments. The status notes can get very long and cumbersome; however, they are very beneficial for the project history. My boss has asked to remove the status notes except for the current month and saved…","categoryID":321,"dateInserted":"2019-08-19T10:41:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-21T14:11:56+00:00","insertUserID":94726,"insertUser":{"userID":94726,"name":"dbrown94726","url":"https:\/\/community.smartsheet.com\/profile\/dbrown94726","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-19T10:30:08+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-11T18:18:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":74,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/55531\/archiving-not-using-control-center","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/55531\/archiving-not-using-control-center","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":274,"urlcode":"Legal","name":"Legal"},{"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}">