制造业

=DATE(2020, 9, 1), Finish:Finish, <=DATE(2020, 9, 30)) * 8 A suggested version has been…","categoryID":322,"dateInserted":"2020-08-21T15:18:51+00:00","dateUpdated":null,"dateLastComment":"2020-08-21T18:10:35+00:00","insertUserID":120384,"insertUser":{"userID":120384,"name":"Larry Bejcar","url":"https:\/\/community.smartsheet.com\/profile\/Larry%20Bejcar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-21T20:40:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"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-02T20:54:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":145,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/70772\/using-ifs-statement-with-date-and-check-box","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70772\/using-ifs-statement-with-date-and-check-box","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-21T20:41:07+00:00","dateAnswered":"2020-08-21T18:10:35+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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"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":19461,"type":"discussion","name":"Wrong Date Showing, Seems to be 4 hours off the difference between GMT and my Time Zone.","excerpt":"As can be seen in the attached screenshot I have data that is brought into the sheet from a web form. A time and date stamp is attached at posting (this time and date is correct) however, the date column beside it that is derived from the function Created is not correct is not. This issue is on all of my sheets and seems…","categoryID":321,"dateInserted":"2018-02-13T14:46:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-08-14T13:31:53+00:00","insertUserID":37731,"insertUser":{"userID":37731,"name":"darryl.barkhouse37731","url":"https:\/\/community.smartsheet.com\/profile\/darryl.barkhouse37731","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-02-13T14:32:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":104586,"lastUser":{"userID":104586,"name":"Mehran Bagherian","url":"https:\/\/community.smartsheet.com\/profile\/Mehran%20Bagherian","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5KNW-RdrbHo!5aFUuSdWdHo!Mtdm2qii6BE","dateLastActive":"2022-08-16T00:34:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":2527,"score":1,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/19461\/wrong-date-showing-seems-to-be-4-hours-off-the-difference-between-gmt-and-my-time-zone","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/19461\/wrong-date-showing-seems-to-be-4-hours-off-the-difference-between-gmt-and-my-time-zone","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-02\/3c\/cb\/3ccb16f7fa897a765d5d224ba7f8a972.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Date issue.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User 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":49676,"type":"discussion","name":"Checkbox to equal 100% in % complete","excerpt":"I am attempting to do the following. If the \"Completed\" column has a check, in the checkbox, I would like the % Complete column to read 100% Here is the formula I thought would work using task 4.of the project. =IF(Completed4 = \"Complete\", \"100%\")","categoryID":322,"dateInserted":"2019-06-03T13:23:06+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-08-07T13:19:56+00:00","insertUserID":90786,"insertUser":{"userID":90786,"name":"chicago25624","url":"https:\/\/community.smartsheet.com\/profile\/chicago25624","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-06\/72\/99\/n7299c000623a798e43e3a6cd5de63b83.jpg","dateLastActive":"2019-08-13T14:14:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":124254,"lastUser":{"userID":124254,"name":"Nick Rozaklis","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Rozaklis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-13T13:57:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":1069,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/49676\/checkbox-to-equal-100-in-complete","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49676\/checkbox-to-equal-100-in-complete","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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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":70356,"type":"question","name":"Return a sum using using sumifs and dates","excerpt":"My objective is to return a sum of all 'Work Hours' that are in a department (Wire in this example), that fall within a date range of the 'END' date that Smartsheet is reporting.. This formula returns a value, but I've checked manually, and I've determined the value is incorrect. I've exported a filtered view of the sheet,…","categoryID":322,"dateInserted":"2020-08-04T17:09:15+00:00","dateUpdated":null,"dateLastComment":"2020-08-05T15:12:37+00:00","insertUserID":120384,"insertUser":{"userID":120384,"name":"Larry Bejcar","url":"https:\/\/community.smartsheet.com\/profile\/Larry%20Bejcar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-21T20:40:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-02T16:20:39+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":74,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/70356\/return-a-sum-using-using-sumifs-and-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70356\/return-a-sum-using-using-sumifs-and-dates","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-05T15:20:02+00:00","dateAnswered":"2020-08-05T15:09:24+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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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":25436,"type":"discussion","name":"Saved Filters Issue Date Type Column","excerpt":"I'm running into a very odd issue with consistent filtering on a date column thats being generated from a formula: We have a column labeled \"Filter date\" that is set to Date (Restrict to dates only not checked) which has the following formula to trim off the date from a 2ndary column that is a drop down: =IF([Date…","categoryID":322,"dateInserted":"2018-05-17T16:20:06+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-07-22T19:25:47+00:00","insertUserID":48321,"insertUser":{"userID":48321,"name":"Ajamieson","url":"https:\/\/community.smartsheet.com\/profile\/Ajamieson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-05\/7a\/83\/n7a83ae8224d78895943a5e466bde7bb8.jpg","dateLastActive":"2018-05-18T09:25:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":124348,"lastUser":{"userID":124348,"name":"Howard Pyett","url":"https:\/\/community.smartsheet.com\/profile\/Howard%20Pyett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-31T11:51:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":176,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/25436\/saved-filters-issue-date-type-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25436\/saved-filters-issue-date-type-column","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-05\/e3\/7e\/e37eff588f80bb55e0494202c67b5c61.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Filter working.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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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":69728,"type":"question","name":"Subtract List Of Parts from Inventory","excerpt":"Hi, I have a Inventory Sheet with list of items and also the quantity of each item. I also have products that use various items from the Inventory list, which I list in the \"Products parts list\", for example: Product #1 requirements = 2 Wheels, 1 axle, and 2 wires. And the way I have set it up now, every time when I sell…","categoryID":321,"dateInserted":"2020-07-09T15:13:10+00:00","dateUpdated":null,"dateLastComment":"2020-07-10T16:44:35+00:00","insertUserID":122780,"insertUser":{"userID":122780,"name":"Benny Neufeld","url":"https:\/\/community.smartsheet.com\/profile\/Benny%20Neufeld","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-25T19:18:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":15201,"lastUser":{"userID":15201,"name":"Doug Carr","url":"https:\/\/community.smartsheet.com\/profile\/Doug%20Carr","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-05\/96\/ae\/n96ae5bfe5eece0bffcb1dc4c4b891d70.png","dateLastActive":"2023-04-12T14:34:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":128,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/69728\/subtract-list-of-parts-from-inventory","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69728\/subtract-list-of-parts-from-inventory","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"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":22626,"type":"discussion","name":"Activity log for certain user","excerpt":"I have noticed on log history that one user has successfully logged in. I have full admin account, can I check his activity since last log in ? ","categoryID":321,"dateInserted":"2018-04-03T16:16:00+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-07-08T09:27:00+00:00","insertUserID":36601,"insertUser":{"userID":36601,"name":"bzgryzek","url":"https:\/\/community.smartsheet.com\/profile\/bzgryzek","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-04\/44\/fe\/n44fe2c7101106ba153cb9e72df9c2c1c.jpg","dateLastActive":"2020-03-28T07:48:52+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-04T17:16:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":710,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/22626\/activity-log-for-certain-user","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/22626\/activity-log-for-certain-user","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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":265,"urlcode":"Reports","name":"Reports"}],"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}">