讨论
TODAY(-7)) How do I get the number of tasks completed, say... between 7-14 days in the past? thank you,","categoryID":322,"dateInserted":"2023-04-03T16:24:15+00:00","dateUpdated":"2023-04-03T16:28:49+00:00","dateLastComment":"2023-04-03T16:49:57+00:00","insertUserID":159013,"insertUser":{"userID":159013,"name":"Allen4480","url":"https:\/\/community.smartsheet.com\/profile\/Allen4480","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-27T16:19:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":159013,"lastUserID":159013,"lastUser":{"userID":159013,"name":"Allen4480","url":"https:\/\/community.smartsheet.com\/profile\/Allen4480","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-27T16:19:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":77,"score":null,"hot":3361080852,"url":"https:\/\/community.smartsheet.com\/discussion\/103524\/of-completed-tasks-between-3-and-2-weeks-ago","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103524\/of-completed-tasks-between-3-and-2-weeks-ago","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-03T16:49:31+00:00","dateAnswered":"2023-04-03T16:45:13+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":103191,"type":"question","name":"Translate Cell value to a specific number","excerpt":"Hello, My Master sheet has one column called \"Portfolio,\". Each cell in that column *may* contain multiple values - up to 5 choices (as shown below) I'd like a new column that would convert those \"names\" to a specified number (ie. 1,2,3,4,5) for example (using below as an example), it would translate to.... 1 1,2,3,4,5…","categoryID":322,"dateInserted":"2023-03-27T16:11:59+00:00","dateUpdated":null,"dateLastComment":"2023-03-29T15:59:21+00:00","insertUserID":159013,"insertUser":{"userID":159013,"name":"Allen4480","url":"https:\/\/community.smartsheet.com\/profile\/Allen4480","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-27T16:19:52+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-10-26T13:24:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":55,"score":null,"hot":3360040880,"url":"https:\/\/community.smartsheet.com\/discussion\/103191\/translate-cell-value-to-a-specific-number","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103191\/translate-cell-value-to-a-specific-number","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/IMFR0OMLTVEK\/screenshot-2023-03-27-120215.jpg","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/IMFR0OMLTVEK\/screenshot-2023-03-27-120215.jpg","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/IMFR0OMLTVEK\/screenshot-2023-03-27-120215.jpg","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/IMFR0OMLTVEK\/screenshot-2023-03-27-120215.jpg","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/IMFR0OMLTVEK\/screenshot-2023-03-27-120215.jpg","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/IMFR0OMLTVEK\/screenshot-2023-03-27-120215.jpg"},"alt":"Screenshot 2023-03-27 120215.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-29T13:57:37+00:00","dateAnswered":"2023-03-27T20:13:31+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":103081,"type":"question","name":"Report: Show me child tasks ONLY if the parent is In-Progress","excerpt":"Hello, I'd like to build a report. My goal is to see only \"Milestone\" tasks (of any status), but only when the Parent Status is \"in-progress\". I can't seem to find the right combination of filters to build this report? Can you help? thank you tons!","categoryID":322,"dateInserted":"2023-03-23T16:54:32+00:00","dateUpdated":"2023-03-23T19:08:02+00:00","dateLastComment":"2023-03-24T15:19:15+00:00","insertUserID":159013,"insertUser":{"userID":159013,"name":"Allen4480","url":"https:\/\/community.smartsheet.com\/profile\/Allen4480","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-27T16:19:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":159013,"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-10-26T13:24:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":90,"score":null,"hot":3359263427,"url":"https:\/\/community.smartsheet.com\/discussion\/103081\/report-show-me-child-tasks-only-if-the-parent-is-in-progress","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103081\/report-show-me-child-tasks-only-if-the-parent-is-in-progress","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/TGMDF9ARP1U7\/noc3-0-project-schedule-smartsheet-com.jpg","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/TGMDF9ARP1U7\/noc3-0-project-schedule-smartsheet-com.jpg","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/TGMDF9ARP1U7\/noc3-0-project-schedule-smartsheet-com.jpg","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/TGMDF9ARP1U7\/noc3-0-project-schedule-smartsheet-com.jpg","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/TGMDF9ARP1U7\/noc3-0-project-schedule-smartsheet-com.jpg","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/TGMDF9ARP1U7\/noc3-0-project-schedule-smartsheet-com.jpg"},"alt":"NOC3_0_Project_Schedule_-_Smartsheet_com.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-23T20:42:15+00:00","dateAnswered":"2023-03-23T20:03:26+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":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}]},{"discussionID":102113,"type":"question","name":"Add Formula to entire column, But leave blank","excerpt":"Hello, I've created a \"Risk Register\". I created two fields (Severity & Likelihood), which, when filled in equal a \"Calculation\" column. However, if I \"fill down\" the calculation formula, it auto-populates as \"high\" even though the previous two criteria are blank. If I try \"convert to column formula\", I get an error. The…","categoryID":322,"dateInserted":"2023-03-03T19:37:08+00:00","dateUpdated":null,"dateLastComment":"2023-03-03T20:10:58+00:00","insertUserID":159013,"insertUser":{"userID":159013,"name":"Allen4480","url":"https:\/\/community.smartsheet.com\/profile\/Allen4480","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-27T16:19:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":128817,"lastUser":{"userID":128817,"name":"Amber Eakin","title":"Instructional Librarian","url":"https:\/\/community.smartsheet.com\/profile\/Amber%20Eakin","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BWFRATSm6no!!36C8hitfthg","dateLastActive":"2023-10-19T17:23:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":99,"score":null,"hot":3355748286,"url":"https:\/\/community.smartsheet.com\/discussion\/102113\/add-formula-to-entire-column-but-leave-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102113\/add-formula-to-entire-column-but-leave-blank","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/BGJ7K9Q8GLGT\/risk-issue-decision-log-smartsheet-com.jpg","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/BGJ7K9Q8GLGT\/risk-issue-decision-log-smartsheet-com.jpg","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/BGJ7K9Q8GLGT\/risk-issue-decision-log-smartsheet-com.jpg","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/BGJ7K9Q8GLGT\/risk-issue-decision-log-smartsheet-com.jpg","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/BGJ7K9Q8GLGT\/risk-issue-decision-log-smartsheet-com.jpg","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/BGJ7K9Q8GLGT\/risk-issue-decision-log-smartsheet-com.jpg"},"alt":"Risk__Issue___Decision_Log_-_Smartsheet_com.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-03T20:12:46+00:00","dateAnswered":"2023-03-03T20:04:52+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}">
