公式

50%) Note: also see that the % completed column is part of the Project Properties. ","categoryID":322,"dateInserted":"2019-01-03T14:59:34+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-03T15:09:56+00:00","insertUserID":74006,"insertUser":{"userID":74006,"name":"dinalu","url":"https:\/\/community.smartsheet.com\/profile\/dinalu","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-03T14:57:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":62701,"lastUser":{"userID":62701,"name":"Brian W","url":"https:\/\/community.smartsheet.com\/profile\/Brian%20W","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJzUbwYJz-LmaGlMRoaP5WjQ9ZaP4MQ1PEwvjWez=s96-c","dateLastActive":"2022-03-18T16:10:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":57,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/38361\/count-rows-by-completed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/38361\/count-rows-by-completed","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-01\/98\/dc\/98dc63ddbb2084c9cfdf36f1570df741.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2019-01-03_14-58-44.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"}],"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":36411,"type":"discussion","name":"Can you auto-replicate rows in a sheet based on a cell value?","excerpt":"We're putting together a Proof of Concept for our project management team. We're \"this close\" to being able to replicate all the functionality they need. But, we're stumbling on one item. They would like Smartsheet to automatically replicate a row when the value in one of the cells is set a certain way. Specifically,…","categoryID":322,"dateInserted":"2018-11-28T08:17:18+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-02T09:43:38+00:00","insertUserID":70166,"insertUser":{"userID":70166,"name":"mrsmorden","url":"https:\/\/community.smartsheet.com\/profile\/mrsmorden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-02T09:22:29+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-08T10:25:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":521,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/36411\/can-you-auto-replicate-rows-in-a-sheet-based-on-a-cell-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/36411\/can-you-auto-replicate-rows-in-a-sheet-based-on-a-cell-value","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":277,"urlcode":"Integrations","name":"Integrations"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">