项目管理

= COUNTIFS(Rating:Rating, \"High-3\",…","categoryID":322,"dateInserted":"2022-06-17T06:31:19+00:00","dateUpdated":"2022-06-17T09:16:58+00:00","dateLastComment":"2022-06-24T13:10:38+00:00","insertUserID":145296,"insertUser":{"userID":145296,"name":"Ann11","url":"https:\/\/community.smartsheet.com\/profile\/Ann11","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-24T15:47:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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":"2022-06-24T13:25:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":19,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/92315\/if-column-does-not-contain-string-return-n-a","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92315\/if-column-does-not-contain-string-return-n-a","format":"Rich","groupID":null,"statusID":8,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/7F6095QH40S5\/screen-shot-2022-06-17-at-3-58-24-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"Screen Shot 2022-06-17 at 3.58.24 pm.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-17T12:55:39+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":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":92352,"type":"question","name":"Project Management with Multiple Subprojects","excerpt":"Hello! I'm looking for recommendations on the best (aka easiest) way to create and manage subprojects within a project. Our current systems are set up to have 1 project number, 2XXXXX, with several subproject numbers, 3XXXXXX, depending on how many phases and shipments of the job there are. The subproject numbers are…","categoryID":321,"dateInserted":"2022-06-17T21:42:14+00:00","dateUpdated":"2022-06-20T08:27:19+00:00","dateLastComment":"2022-06-24T11:12:06+00:00","insertUserID":146586,"insertUser":{"userID":146586,"name":"Amber Lange","url":"https:\/\/community.smartsheet.com\/profile\/Amber%20Lange","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pCkqKV-RqAs!ZLtpWYOIb3M!byRgIG5TwvB","dateLastActive":"2022-06-22T16:32:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-06-24T16:55:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":36,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/92352\/project-management-with-multiple-subprojects","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92352\/project-management-with-multiple-subprojects","format":"Rich","groupID":null,"statusID":8,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-24T11:12: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":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":92514,"type":"idea","name":"Inlclude predecessor references with copy to another sheet","excerpt":"Sorry if this is already in the forum. I searched and did not see it submitted as an idea. It only comes up in other discussions. Issue: When using copy to another sheet, the rows do not maintain their predecessor references. Use Case: We utilize Control Center to provision our projects from a standard \"PROJECT TEMPLATE\".…","categoryID":349,"dateInserted":"2022-06-22T20:23:20+00:00","dateUpdated":"2022-06-23T11:26:32+00:00","dateLastComment":"2022-06-22T20:23:20+00:00","insertUserID":137695,"insertUser":{"userID":137695,"name":"Tim Starkey","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20Starkey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uolS96T7mzo!84NRtwSFw3o!n5WODiM4TKP","dateLastActive":"2022-06-23T13:58:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":137695,"lastUser":{"userID":137695,"name":"Tim Starkey","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20Starkey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uolS96T7mzo!84NRtwSFw3o!n5WODiM4TKP","dateLastActive":"2022-06-23T13:58:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":12,"score":1,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/92514\/inlclude-predecessor-references-with-copy-to-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92514\/inlclude-predecessor-references-with-copy-to-another-sheet","format":"Rich","groupID":null,"statusID":8,"attributes":{"idea":{"statusNotes":null,"statusID":1,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":92462,"type":"question","name":"Creating a Booking System with a Time Component","excerpt":"Hi everyone, I have the following asset booking system and received feedback that I should add a time component to it: Unfortunately, I haven't been able to get it to work correctly as, in the above screenshot, you can see that the booker is stating the asset is available when it is not. Additionally, the 'Assignee in…","categoryID":322,"dateInserted":"2022-06-22T04:21:57+00:00","dateUpdated":"2022-06-22T09:51:23+00:00","dateLastComment":"2022-06-22T04:21:57+00:00","insertUserID":148789,"insertUser":{"userID":148789,"name":"JJL","url":"https:\/\/community.smartsheet.com\/profile\/JJL","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-24T04:07:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":148789,"lastUser":{"userID":148789,"name":"JJL","url":"https:\/\/community.smartsheet.com\/profile\/JJL","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-24T04:07:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":21,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/92462\/creating-a-booking-system-with-a-time-component","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92462\/creating-a-booking-system-with-a-time-component","format":"Rich","groupID":null,"statusID":8,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/XKMH0VLNQXOL\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"image.png"},"attributes":{"question":{"status":"unanswered","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":242,"urlcode":"Resource Views","name":"Resource Views"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"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":92217,"type":"idea","name":"Constraint Types in Gantt View","excerpt":"Requesting the ability to use constraint types in a project (Gantt view), similar to the options in MS Project: As Late as Possible As Soon as Possible Finish No Earlier Than Finish No Later Than Must Finish On Must Start On Start No Earlier Than Start No Later Than","categoryID":349,"dateInserted":"2022-06-15T18:39:18+00:00","dateUpdated":"2022-06-15T19:21:59+00:00","dateLastComment":"2022-06-15T18:39:18+00:00","insertUserID":130269,"insertUser":{"userID":130269,"name":"Steven Munsey","url":"https:\/\/community.smartsheet.com\/profile\/Steven%20Munsey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2SjUvm9QM6Y!5UtW-RNra7w!zrM190lFbmp","dateLastActive":"2022-06-16T13:40:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":130269,"lastUser":{"userID":130269,"name":"Steven Munsey","url":"https:\/\/community.smartsheet.com\/profile\/Steven%20Munsey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2SjUvm9QM6Y!5UtW-RNra7w!zrM190lFbmp","dateLastActive":"2022-06-16T13:40:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":25,"score":3,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/92217\/constraint-types-in-gantt-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92217\/constraint-types-in-gantt-view","format":"Rich","groupID":null,"statusID":8,"attributes":{"idea":{"statusNotes":null,"statusID":1,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">