添加插件和集成
讨论表
类别
受欢迎的标签
Have you set predecessors in your project?<\/p>
If not, the actual date change that does not affect the parent level date shows 0 variances at the parent level.<\/p>
😀<\/span><\/p> Hi @Zach Kinser<\/a> <\/p> I hope you're well and safe!<\/p> If you check the Workflow templates, you'll find this one.<\/p> Would that work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":103697,"type":"question","name":"Row Report, Count Distinct and Summary Formula?","excerpt":"I have a row report that I am building off of a sheet that includes the date, name, and time spent on a task. I am wanting to build a row report grouped by name, that summarizes the sum of the time spent on a task and the count of distinct dates. The part that I am struggling with is counting the distinct dates, as I only…","categoryID":321,"dateInserted":"2023-04-06T15:17:24+00:00","dateUpdated":null,"dateLastComment":"2023-04-06T15:21:28+00:00","insertUserID":149440,"insertUser":{"userID":149440,"name":"OORF","url":"https:\/\/community.smartsheet.com\/profile\/OORF","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-07T19:25:44+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-04-07T20:57:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":27,"score":null,"hot":3361589332,"url":"https:\/\/community.smartsheet.com\/discussion\/103697\/row-report-count-distinct-and-summary-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103697\/row-report-count-distinct-and-summary-formula","format":"Rich","tagIDs":[254,265],"lastPost":{"discussionID":103697,"commentID":370654,"name":"Re: Row Report, Count Distinct and Summary Formula?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/370654#Comment_370654","dateInserted":"2023-04-06T15:21:28+00:00","insertUserID":45516,"insertUser":{"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-04-07T20:57:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/QTOYB8CVWJ5Q\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-06T15:24:41+00:00","dateAnswered":"2023-04-06T15:21:28+00:00","acceptedAnswers":[{"commentID":370654,"body":" To get the summary value, you would need to create a sub-grouping in the report.<\/p> You will not be able to perform additional calculations off of this data within the report though. You would need to create a separate sheet and use formulas with cross sheet references looking at the actual source data (not the report) to get that average.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">![\"baseline](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/K4IDVIIXT9OO\/baseline-with-indented-rows.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>
<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":103698,"type":"question","name":"Automation trigger on row deletion","excerpt":"How do you trigger a automation when a row has been deleted? I found a older post from 2020 with instructions but those seem outdated now as well.","categoryID":321,"dateInserted":"2023-04-06T15:32:08+00:00","dateUpdated":null,"dateLastComment":"2023-04-06T16:04:35+00:00","insertUserID":149520,"insertUser":{"userID":149520,"name":"Zach Kinser","url":"https:\/\/community.smartsheet.com\/profile\/Zach%20Kinser","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-06T16:21:12+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\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-04-07T23:24:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":17,"score":null,"hot":3361592803,"url":"https:\/\/community.smartsheet.com\/discussion\/103698\/automation-trigger-on-row-deletion","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103698\/automation-trigger-on-row-deletion","format":"Rich","lastPost":{"discussionID":103698,"commentID":370674,"name":"Re: Automation trigger on row deletion","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/370674#Comment_370674","dateInserted":"2023-04-06T16:04:35+00:00","insertUserID":8888,"insertUser":{"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\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-04-07T23:24:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-06T16:23:41+00:00","dateAnswered":"2023-04-06T16:04:35+00:00","acceptedAnswers":[{"commentID":370674,"body":"![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/8WOC7DFK5B60\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>
