讨论
1\/1\/18\")","categoryID":322,"dateInserted":"2018-09-16T02:29:59+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-09-21T17:13:10+00:00","insertUserID":61161,"insertUser":{"userID":61161,"name":"laura.buchanan","url":"https:\/\/community.smartsheet.com\/profile\/laura.buchanan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-01T00:58:40+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":32,"countViews":9358,"score":null,"hot":3200864589,"url":"https:\/\/community.smartsheet.com\/discussion\/32031\/countif-with-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/32031\/countif-with-dates","format":"Html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-06-22T16:10:53+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":234,"urlcode":"health-care","name":"Healthcare"},{"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":75214,"type":"question","name":"How to deconcatinate","excerpt":"I need to be able to separate out the five sections separated by commas into five adjacent blank columns ED Class, Wednesday, 01\/20\/21, 9:00 am - 12:30 pm, Happy Hospital Thanks, Laura","categoryID":322,"dateInserted":"2021-01-24T05:02:17+00:00","dateUpdated":null,"dateLastComment":"2021-01-29T22:31:45+00:00","insertUserID":61161,"insertUser":{"userID":61161,"name":"laura.buchanan","url":"https:\/\/community.smartsheet.com\/profile\/laura.buchanan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-01T00:58:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":61161,"lastUser":{"userID":61161,"name":"laura.buchanan","url":"https:\/\/community.smartsheet.com\/profile\/laura.buchanan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-01T00:58:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":128,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/75214\/how-to-deconcatinate","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75214\/how-to-deconcatinate","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-01-24T06:05:16+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":[],"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":73378,"type":"question","name":"reference another sheet - not from a cell, but pull from sheet summary formula","excerpt":"Hi, I need to pull a sheet summary formula into another sheet. I've tried right clicking in the desired cell, link to cell in another sheet, but can only link to actual cells in the other sheet. I can't navigate over to the formulas in the sheet summary section right hand side to pull that in. Another option I tried was…","categoryID":322,"dateInserted":"2020-11-20T22:48:54+00:00","dateUpdated":null,"dateLastComment":"2020-11-23T10:58:59+00:00","insertUserID":61161,"insertUser":{"userID":61161,"name":"laura.buchanan","url":"https:\/\/community.smartsheet.com\/profile\/laura.buchanan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-01T00:58:40+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-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":164,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/73378\/reference-another-sheet-not-from-a-cell-but-pull-from-sheet-summary-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/73378\/reference-another-sheet-not-from-a-cell-but-pull-from-sheet-summary-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-11-21T22:17:15+00:00","dateAnswered":"2020-11-21T10:41:58+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":[],"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":70367,"type":"question","name":"Need formula to pull data from Last week Sun through Sat","excerpt":"The formula below is working perfectly pulling the time Laura Spent on Projects, year to date. Now the boss wants, instead of year to date, he wants to display only Dates from the previous Sun - Sat. So we want our graph to always show the data for LAST week. So no matter what day I'm looking at it THIS week. I want to see…","categoryID":322,"dateInserted":"2020-08-05T03:11:50+00:00","dateUpdated":null,"dateLastComment":"2020-08-11T11:31:35+00:00","insertUserID":61161,"insertUser":{"userID":61161,"name":"laura.buchanan","url":"https:\/\/community.smartsheet.com\/profile\/laura.buchanan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-01T00:58:40+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":412,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/70367\/need-formula-to-pull-data-from-last-week-sun-through-sat","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70367\/need-formula-to-pull-data-from-last-week-sun-through-sat","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","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":[],"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":70297,"type":"question","name":"Need help with =SUMIF in summary report","excerpt":"I'm trying to get a sum of time spent for week ending date 7\/31\/20. This formula gives me a total of zero. Any suggestions for what I'm doing wrong? I've tried the date with and without \" \". Thanks! =SUMIF([Week Ending Date]:[Week Ending Date], =\"07\/31\/20\", [Time Spent]:[Time Spent])","categoryID":322,"dateInserted":"2020-08-02T01:20:29+00:00","dateUpdated":null,"dateLastComment":"2020-08-04T05:28:30+00:00","insertUserID":61161,"insertUser":{"userID":61161,"name":"laura.buchanan","url":"https:\/\/community.smartsheet.com\/profile\/laura.buchanan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-01T00:58:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":122299,"lastUser":{"userID":122299,"name":"Stefan","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Stefan","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nJVa34H1C4Q!HEtZnwWHg7o!c2eUa44FlAn","dateLastActive":"2023-08-24T06:42:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":74,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/70297\/need-help-with-sumif-in-summary-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70297\/need-help-with-sumif-in-summary-report","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/T2QDNTST97A1\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-03T21:52:12+00:00","dateAnswered":"2020-08-03T08:34:58+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":[],"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":false,"noCheckboxes":true}">
