你能在没有子任务的情况下复制工作流中的单元格吗?
我创建了一个工作流，当满足行中的值时，将某些行复制到新工作表中。我遇到的问题是，我只是想复制符合该标准的任何行(父或子)-如果它只是父任务，我不希望所有的子任务也被复制。有办法做到这一点吗?
最佳答案
答案
-
迈克电视 ✭✭✭✭✭✭
我不这么认为。我测试过了，看不出你是怎么做到的。如果您试图删除任何工作表上的父行，它也会删除子行。我相信SmartSheet将父/子行视为一行。大多数动作都与父进程和子进程有关。
您需要填写一个增强请求，请求为父子行添加不同的功能。在此过程中，请确保请求一个公式函数来创建或取消创建父/子行层次结构。它已经被需要太久了。
-
mx ✭谢谢,迈克!
-
她名叫Stara ✭✭✭✭✭✭嗨@MXS
我希望你一切安好!
再加上迈克的绝妙建议/答案。
这里有一个或多个可行的解决方案
- 您可以创建一个所谓的Helper表，并使用跨表公式结合VLOOKUP或INDEX/MATCH结构来连接表。当您更新源工作表时，它将反映到目标工作表(Helper工作表)上，然后您将使用没有任何层次结构的工作表来复制行。
有意义吗?
那会有用吗?
我希望这对你有所帮助!
注意安全，周末愉快!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为深刻的/投票或/和作为公认的答案．这将使其他人更容易找到解决方案或帮助回答!
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
关于Smartsheet、集成、一般工作流建议或其他方面的帮助，请随时与我联系。
帮助文章资源欧宝体育app官方888
类别
Hi @Rudy Biagi<\/a> <\/p> Try this: =COUNTIFS({Master Pipeline Tracker Range 1}, \"LEASE NEGOTIATING\", {Master Pipeline Tracker Range 3}, >=DATE(2023, 1, 1), {Master Pipeline Tracker Range 3}, <=DATE(2023, 12, 31))<\/p> Hope this helps.,<\/p> Dave<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-14 22:44:57","updateUser":{"userID":158296,"name":"Rudy Biagi","url":"https:\/\/community.smartsheet.com\/profile\/Rudy%20Biagi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-14T22:44:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":101113,"type":"question","name":"Formula to always Summarize all 5 cells to the right of a column, including new columns added.","excerpt":"Hi, Is there any formula that can return the summary of any of the 5 columns to the right of this column layout, no matter what columns are inserted from there on? I keep on adding columns, but I want it to always calculate the columns that are now (or in the future) within 5 columns to the right. Thank you,","categoryID":322,"dateInserted":"2023-02-14T17:58:07+00:00","dateUpdated":"2023-02-14T17:59:08+00:00","dateLastComment":"2023-02-14T21:13:05+00:00","insertUserID":123243,"insertUser":{"userID":123243,"name":"A Rose","title":"","url":"https:\/\/community.smartsheet.com\/profile\/A%20Rose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-14T21:13:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":123243,"lastUserID":123243,"lastUser":{"userID":123243,"name":"A Rose","title":"","url":"https:\/\/community.smartsheet.com\/profile\/A%20Rose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-14T21:13:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":44,"score":null,"hot":3352812072,"url":"https:\/\/community.smartsheet.com\/discussion\/101113\/formula-to-always-summarize-all-5-cells-to-the-right-of-a-column-including-new-columns-added","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101113\/formula-to-always-summarize-all-5-cells-to-the-right-of-a-column-including-new-columns-added","format":"Rich","tagIDs":[254,319],"lastPost":{"discussionID":101113,"commentID":362278,"name":"Re: Formula to always Summarize all 5 cells to the right of a column, including new columns added.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/362278#Comment_362278","dateInserted":"2023-02-14T21:13:05+00:00","insertUserID":123243,"insertUser":{"userID":123243,"name":"A Rose","title":"","url":"https:\/\/community.smartsheet.com\/profile\/A%20Rose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-14T21:13:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-14T21:13:08+00:00","dateAnswered":"2023-02-14T21:06:38+00:00","acceptedAnswers":[{"commentID":362273,"body":" @A Rose<\/a> <\/p> This is one of those situations where you need to reevaluate your sheet design and how you're using it. When you require something to be done a very specific way and SmartSheet isn't designed to do that or doesn't have a formula created to do that, then you need to step back and re-think how you want your sheet to work with SmartSheet limitations in mind and design a working version doing things differently.<\/p>"},{"commentID":362278,"body":" That is true Mike!<\/p> For anyone with the same issue:<\/p> I might start clearing old columns with the clear cell value automation and re-use those same columns.<\/p> Thanks,<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-14 21:13:08","updateUser":{"userID":123243,"name":"A Rose","title":"","url":"https:\/\/community.smartsheet.com\/profile\/A%20Rose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-14T21:13:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":319,"urlcode":"functionality","name":"functionality"}]},{"discussionID":101102,"type":"question","name":"For Network Days formula how do I ignore blank date rows","excerpt":"Using this formula to calculate duration of a project =NETWORKDAY([PoC start date]@row, [PoC End date]@row) But for blank rows - \"Invalid Data Type\" is entered Hence when I try to average the duration - I am receiving \"Invalid Data Type\" error. How can I edit the above Network days formula to ignore blank cells ?","categoryID":322,"dateInserted":"2023-02-14T16:11:42+00:00","dateUpdated":null,"dateLastComment":"2023-02-14T16:50:23+00:00","insertUserID":153291,"insertUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-14T17:46:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":86866,"lastUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2023-02-14T22:45:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":27,"score":null,"hot":3352786925,"url":"https:\/\/community.smartsheet.com\/discussion\/101102\/for-network-days-formula-how-do-i-ignore-blank-date-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101102\/for-network-days-formula-how-do-i-ignore-blank-date-rows","format":"Rich","lastPost":{"discussionID":101102,"commentID":362198,"name":"Re: For Network Days formula how do I ignore blank date rows","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/362198#Comment_362198","dateInserted":"2023-02-14T16:50:23+00:00","insertUserID":86866,"insertUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2023-02-14T22:45:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-14T16:28:59+00:00","dateAnswered":"2023-02-14T16:24:41+00:00","acceptedAnswers":[{"commentID":362189,"body":" Try an IFERROR like so:<\/p> =IFERROR(<\/strong>NETWORKDAY([PoC start date]@row, [PoC End date]@row), \"//www.santa-greenland.com/community/discussion/91338/\")<\/strong><\/p>"},{"commentID":362192,"body":" @keesuri25<\/a> You can suppress error messages by wrapping your formula in IFERROR<\/a>: <\/p> =IFERROR(<\/strong>NETWORKDAY([PoC start date]@row, [PoC End date]@row), \"//www.santa-greenland.com/community/discussion/91338/\")<\/strong><\/p> This replaces any error messages with \"//www.santa-greenland.com/community/discussion/91338/\", aka a blank cell.<\/p>
