建设

\"No\", @cell <> \"Complete\"), {(Phoenix) Project Tracker - Status column}, AND(@cell = \"Complete\"), {(Phoenix) Project Tracker -…","categoryID":322,"dateInserted":"2021-06-20T03:22:58+00:00","dateUpdated":null,"dateLastComment":"2021-06-20T19:54:14+00:00","insertUserID":137250,"insertUser":{"userID":137250,"name":"Megan Kauffman","url":"https:\/\/community.smartsheet.com\/profile\/Megan%20Kauffman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-11-29T19:44:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":112221,"lastUser":{"userID":112221,"name":"Kelly Moore","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2022-10-10T17:49:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":31,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/80519\/how-to-create-this-countifs-with-and-or-not","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/80519\/how-to-create-this-countifs-with-and-or-not","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-06-20T19:54:14+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":218,"urlcode":"Construction","name":"Construction"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"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":70746,"type":"question","name":"One off Saturdays in Gantt","excerpt":"Hi all, I work in construction and use the gantt chart heavily to manage scheduling subs. I have a unique situation for my project where I may have to schedule work on a Saturday. Is there any way to allow a single Saturday, instead of opening Saturdays for the duration of project?","categoryID":321,"dateInserted":"2020-08-20T17:41:31+00:00","dateUpdated":null,"dateLastComment":"2021-06-18T21:45:02+00:00","insertUserID":121091,"insertUser":{"userID":121091,"name":"Molly Hanson","url":"https:\/\/community.smartsheet.com\/profile\/Molly%20Hanson","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GjK9vay6CSPLUL-bpO6g016cIhjtH7N9-zCWzsYUQ=s96-c","dateLastActive":"2021-01-27T12:26:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137234,"lastUser":{"userID":137234,"name":"Austin Clos","url":"https:\/\/community.smartsheet.com\/profile\/Austin%20Clos","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pM1Y6UG-p6Q!umDfd2hLkmQ!Pz5OqgcliFB","dateLastActive":"2021-07-10T16:21:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":31,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/70746\/one-off-saturdays-in-gantt","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70746\/one-off-saturdays-in-gantt","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-08-20T23:18:47+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":218,"urlcode":"Construction","name":"Construction"},{"tagID":269,"urlcode":"Gantt View","name":"Gantt View"},{"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}]},{"discussionID":56831,"type":"discussion","name":"Jira Connector only allowing one project to one sheet","excerpt":"Hi, We have recently implemented the Jira connector for Smartsheet and this is working well in each sheet where we have a one to one relationship with Jira Projects. We have a single sheet which is collating all enhancement requests (using a web form as a front end) which will place enhancements into the relevant Project…","categoryID":343,"dateInserted":"2019-09-01T20:58:20+00:00","dateUpdated":"2022-06-14T14:36:34+00:00","dateLastComment":"2021-06-15T03:28:40+00:00","insertUserID":97696,"insertUser":{"userID":97696,"name":"Ed Sheaf","url":"https:\/\/community.smartsheet.com\/profile\/Ed%20Sheaf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-07-20T22:02:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":97696,"lastUser":{"userID":97696,"name":"Ed Sheaf","url":"https:\/\/community.smartsheet.com\/profile\/Ed%20Sheaf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-07-20T22:02:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":371,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/56831\/jira-connector-only-allowing-one-project-to-one-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/56831\/jira-connector-only-allowing-one-project-to-one-sheet","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-09\/bc\/3e\/bc3e4dc23d02f1ccc4ee40b96c621332.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"jira connector error.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":259,"urlcode":"IT & Operations","name":"IT & Operations"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":278,"urlcode":"Importing and Exporting","name":"Importing and Exporting"}],"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":50811,"type":"discussion","name":"Formula to copy the information of one cell into a different cell","excerpt":"Is it possible to use a formula to copy the information of one cell ( In this case the cell is under a date type column) to another cell (also a date type column) . For example, if my cell #1 under column \"concept start date\" is: 06\/19\/19 then automatically my cell #1 under column \"Start\" would automatically fill up as…","categoryID":322,"dateInserted":"2019-06-17T14:36:51+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-06-03T15:24:14+00:00","insertUserID":92641,"insertUser":{"userID":92641,"name":"@Help","url":"https:\/\/community.smartsheet.com\/profile\/%40Help","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-29T12:10:04+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"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-10-10T21:18:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":1121,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/50811\/formula-to-copy-the-information-of-one-cell-into-a-different-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/50811\/formula-to-copy-the-information-of-one-cell-into-a-different-cell","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":218,"urlcode":"Construction","name":"Construction"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"}],"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":24701,"type":"discussion","name":"How do I calculate the difference between 2 dates?","excerpt":"Trying to track variable durations of past projects and simply want to subtract the start date from the completion date... depending on which format the column is in, I get various errors. Seems like I should be able to simply subtract one cell from the other, no? ","categoryID":321,"dateInserted":"2018-05-03T14:19:06+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-05-19T20:51:56+00:00","insertUserID":39706,"insertUser":{"userID":39706,"name":"jretzlaff","url":"https:\/\/community.smartsheet.com\/profile\/jretzlaff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-21T12:55:51+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":103711,"lastUser":{"userID":103711,"name":"Christopher Wirth","url":"https:\/\/community.smartsheet.com\/profile\/Christopher%20Wirth","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-11-10T17:53:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":9698,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/24701\/how-do-i-calculate-the-difference-between-2-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/24701\/how-do-i-calculate-the-difference-between-2-dates","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-05\/80\/c8\/80c87dc4d507b4297f8e620cce064087.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"}],"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":79286,"type":"question","name":"Auto Functions w\/ Update Requests","excerpt":"Hello, I am trying to figure out if there is a way to 1) automatically add a new child row once someone has completed an update and 2) send out a \"report\" of updates (children rows) with the update requests so the person who the task is assigned to can see their previous updates. As of right now I add a new child row…","categoryID":321,"dateInserted":"2021-05-11T14:38:09+00:00","dateUpdated":null,"dateLastComment":"2021-05-13T14:57:22+00:00","insertUserID":64321,"insertUser":{"userID":64321,"name":"Andrew Moore","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20Moore","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-09T14:40:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-10T15:55:43+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":81,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/79286\/auto-functions-w-update-requests","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/79286\/auto-functions-w-update-requests","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/G6QO34MXU7VK\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-05-13T15:10:26+00:00","dateAnswered":"2021-05-13T14:57:22+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":218,"urlcode":"Construction","name":"Construction"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}">