自动前驱调整

ryan.diamond55371
ryan.diamond55371 ✭✭
编辑12/09/19 在公式和函数

嘿!

我有一个问题，关于如何在时间表中有前任或任务，当它们在时间表中移动时自动更新。我正在尝试为我们的钣金车间创建一个生产计划，它是ob欧宝娱乐app手机下载与工程部发布的制造包一起创建的。有时需要根据现场工作人员或完成其他任务的新优先级调整计划。目标是让车间经理能够:A)为公司制定未来2到3周的计划B)能够通过拖拽“Release”来调整进度，并将其放入进度中，并使先前的进度进行相应的更新。提前感谢社区在这方面的帮助!

标签:
· 在Facebook上分享 在Twitter上分享

评论

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    嗨,瑞安,

    你能更详细地描述一下你的过程吗?也许可以分享一下表格或一些截图?这样就更容易帮忙了。(分享,(电子邮件保护)）

    新年快乐!

    最好的

    她名叫Stara

    工作流程顾问@完成咨询

    智能表专家顾问兼合伙人

    https://workbold.com/

    她名叫Stara|工作流程顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。

    · 在Facebook上分享 在Twitter上分享
  • JamieRH
    JamieRH ✭

    我很想听听你的发现，因为我在我们的日程安排中遇到了类似的困境!

    · 在Facebook上分享 在Twitter上分享
  • ryan.diamond55371
    ryan.diamond55371 ✭✭

    下面是它可能看起来的一个片段。我现在遇到的问题是，无论你把任务转移到哪里，前任都与他们上面的任何一行保持联系。我需要任务的顺序与我安排它们的顺序一致，而不必每次都更新前一个或多个单元格。

    ob欧宝娱乐app手机下载生产Schedule.JPG

    · 在Facebook上分享 在Twitter上分享
  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    嗨,瑞安,

    我完全错过了你的帖子。你准备好解决方案了吗?

    祝你一周愉快!

    最好的

    她名叫Stara

    工作流程顾问@完成咨询

    智能表专家顾问兼合伙人

    https://workbold.com/

    她名叫Stara|工作流程顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。

    · 在Facebook上分享 在Twitter上分享
  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    你好杰米,

    我完全错过了你的帖子。你准备好解决方案了吗?

    祝你一周愉快!

    最好的

    她名叫Stara

    工作流程顾问@完成咨询

    智能表专家顾问兼合伙人

    https://workbold.com/

    她名叫Stara|工作流程顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。

    · 在Facebook上分享 在Twitter上分享
  • Jon Wilbur Tan
    Jon Wilbur Tan ✭
    编辑07/15/20

    我的天啊。读到这里我很失望。自2019年以来，已经有两人提出了这种担忧!

    这是非常有效的，是任何一种甘特图软件的标准。我之前就这个问题发短信给支持人员。

    1. 缺失暗模式
    2. Flakey键盘支持。在iPad Pro上，它一直消失。目前的解决方案是继续点击其他单元格或退出并重新启动应用程序。
    3. 自动更新之前的编号，正如这些人提到的。编号应该总是自动更改。前置任务应该始终链接到任务行，并且该任务行应该可以移动到计划中的任何编号或插槽。这将导致前身槽自动更改编号。例如，如果它位于5号槽，你向磁盘添加了更多行，它必须移动到8号槽，那么作为前身链接到它的所有内容都需要从5更改到8。

    看完评论后，我真的很震惊，这是不理解和不清楚的。无论如何，我希望我帮助解释它，并解决这个问题，因为任何严肃的软件必须有这个功能。想象一下有10个或更多的前任相关任务!真是一场噩梦!请尽快解决这个问题。到2020年已经过半了。

    编辑:

    对于那些像我们这样被应用程序行为迷惑的评论者。我刚刚发现，该应用程序目前确实在前任中进行自动细胞识别，但你必须点击位于iOS屏幕右上角的“更新/刷新”图标。仍然很疯狂，但至少它在那里。希望这将被纠正，因为我们不能指望保持按刷新所有的时间，因为我们不断做出改变。

    · 在Facebook上分享 在Twitter上分享
  • Lllllloyd
    Lllllloyd ✭

    乔恩·威尔伯·谭!

    我想你能帮我节省很多时间。我是调度大师。我去了一家制造库存厂到一家工程师订货店。他们想让我使用这个智能表格程序，你知道，不要太破旧。虽然有限。这个软件是为项目工作。我们公司有一个部门负责大型建筑设计，这就是智能手机的亮点所在。这就是我要做的。

    工艺流程;

    1. 由原材料制成的空白
    2. 空白反冲原料!
    3. 空白移动形成过程
    4. 表单处理反冲洗空白
    5. 成形件移动到装配(WIP)
    6. 组装完成
    7. 反冲在制品

    部件已准备好发货

    所有的零件运动都需要在某个时候转移到QC进行流程检查。

    我不愿意为所有这些创建一个访问数据库。我以前做过，花了一年的时间把一切都解决了....


    · 在Facebook上分享 在Twitter上分享
  • 乔H
    乔H ✭✭

    所以我在PC上这样做，当我添加新行时，我找不到一种方法让它自动更新。

    问题是，我开始这是一个全新的项目类型，我经常添加新的行，而我了解的项目。要更新多达75行代码是很愚蠢的

    · 在Facebook上分享 在Twitter上分享

帮助文章参考资料欧宝体育app官方888

在智能表中创建和编辑公式

交叉表引用的公式组合

智能表功能列表

类别

想要直接在智能表中练习使用公式吗?

请查看公式手册模板!

进入赢取免费会议通行证到ENGAGE 2023。

 了解更多
TODAY(), Fleet:Fleet, \"A220\")","categoryID":322,"dateInserted":"2023-06-21T16:14:49+00:00","dateUpdated":null,"dateLastComment":"2023-06-21T20:20:41+00:00","insertUserID":162138,"insertUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T20:28:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":162138,"lastUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T20:28:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":35,"score":null,"hot":3374745330,"url":"https:\/\/community.smartsheet.com\/discussion\/106707\/how-to-count-how-many-interviews-in-the-current-week","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106707\/how-to-count-how-many-interviews-in-the-current-week","format":"Rich","lastPost":{"discussionID":106707,"commentID":381628,"name":"Re: How to count how many interviews in the current week?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381628#Comment_381628","dateInserted":"2023-06-21T20:20:41+00:00","insertUserID":162138,"insertUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T20:28:23+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/TNZRUD6K3A2N\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-21T20:21:04+00:00","dateAnswered":"2023-06-21T19:39:48+00:00","acceptedAnswers":[{"commentID":381601,"body":"

@Louis.Smith<\/a>,<\/p>

Awesome, glad it worked! Please remember to click the Answer button if you don't mind. <\/p>

Re: \"Is there a way to create a formula for the current?\" - By this do you mean for the current week?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":106700,"type":"question","name":"If Or Formula Help","excerpt":"My formula is working in Excel, but not in Smartsheet. I am still fairly new to smartsheet so any help would be appreciated. Basically its looking at the GLAcct column and find certain values and creating key terms for those values. Ex: If GLAcct = 710111 or 710121, then show Key Salary.","categoryID":322,"dateInserted":"2023-06-21T15:12:46+00:00","dateUpdated":null,"dateLastComment":"2023-06-21T17:02:32+00:00","insertUserID":162062,"insertUser":{"userID":162062,"name":"mragans23","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/mragans23","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T18:21:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162062,"lastUser":{"userID":162062,"name":"mragans23","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/mragans23","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T18:21:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3374728518,"url":"https:\/\/community.smartsheet.com\/discussion\/106700\/if-or-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106700\/if-or-formula-help","format":"Rich","lastPost":{"discussionID":106700,"commentID":381545,"name":"Re: If Or Formula Help","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381545#Comment_381545","dateInserted":"2023-06-21T17:02:32+00:00","insertUserID":162062,"insertUser":{"userID":162062,"name":"mragans23","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/mragans23","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T18:21:45+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/WU7DXUC1MGJ2\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-21T18:54:42+00:00","dateAnswered":"2023-06-21T15:29:14+00:00","acceptedAnswers":[{"commentID":381516,"body":"

Hi @mragans23<\/a>,<\/p>

In Smartsheet you'd need to add @row to the GLAcct portion of your the formula. <\/p>

For example, the first section would be:<\/p>

=IF(OR(GLAcct@row = \"710111\", GLAcct@row = \"710121\"), \"Key Salary\")<\/p>

Once you've entered it for one row, you can then right click the cell and \"Convert to Column Formula\" to have it applied to all rows in the column. <\/p>

Other than that, I think everything should be OK once you add the @row in.<\/p>

Hope that helps; any questions etc. then just post! 😊<\/span><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":106682,"type":"question","name":"Make sum of one column in function of value of another","excerpt":"Hello everybody, I did not find my answer in the different discussions, then I hope you will be able to help me. I have a smart sheet with 2 columns: Part number Quantity I would like to count the total of parts with a certain number. Finally, it is an addition of the quantity when the P\/N is equal to a certain value. I…","categoryID":322,"dateInserted":"2023-06-21T06:31:14+00:00","dateUpdated":"2023-06-21T07:41:41+00:00","dateLastComment":"2023-06-21T11:14:19+00:00","insertUserID":159154,"insertUser":{"userID":159154,"name":"Guillaume B.","url":"https:\/\/community.smartsheet.com\/profile\/Guillaume%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/S5NT3AR3967R\/nA4FRK2S3XJG9.jpg","dateLastActive":"2023-06-21T13:09:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":159154,"lastUserID":159154,"lastUser":{"userID":159154,"name":"Guillaume B.","url":"https:\/\/community.smartsheet.com\/profile\/Guillaume%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/S5NT3AR3967R\/nA4FRK2S3XJG9.jpg","dateLastActive":"2023-06-21T13:09:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":34,"score":null,"hot":3374676333,"url":"https:\/\/community.smartsheet.com\/discussion\/106682\/make-sum-of-one-column-in-function-of-value-of-another","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106682\/make-sum-of-one-column-in-function-of-value-of-another","format":"Rich","lastPost":{"discussionID":106682,"commentID":381436,"name":"Re: Make sum of one column in function of value of another","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381436#Comment_381436","dateInserted":"2023-06-21T11:14:19+00:00","insertUserID":159154,"insertUser":{"userID":159154,"name":"Guillaume B.","url":"https:\/\/community.smartsheet.com\/profile\/Guillaume%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/S5NT3AR3967R\/nA4FRK2S3XJG9.jpg","dateLastActive":"2023-06-21T13:09:56+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-06-21T11:14:29+00:00","dateAnswered":"2023-06-21T11:14:19+00:00","acceptedAnswers":[{"commentID":381436,"body":"

I finally found the correct formula:<\/p>

=SUMIF([Part number]$185:[Part number]$369, CONTAINS([Part number]167, @cell), Quantity$185:Quantity$369)<\/code><\/strong><\/p>

Like that it is working partially, because as I have sub assemblies, I will need to take the quantity of the PARENT() and multiply it to have the correct value.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

公式和函数趋势

  • 如何计算本周面试的次数?

    我目前正在尝试跟踪每个机队类型在本周安排了多少次面试?我的公式是从今天算起的7天，但不包括今天。=COUNTIFS([面试日期]:[面试日期]，@cell =今天(7)，[面试日期]:[面试日期]，@cell >今天()，舰队:舰队，“A220”)

  • 如果或公式帮助

    我的公式在Excel中工作，但在Smartsheet中不行。我仍然是相当新的智能表，所以任何帮助将不胜感激。它查看GLAcct列，找到某些值并为这些值创建关键字。例如:如果GLAcct = 710111或710121，则显示Key Salary。

  • 求一列值与另一列值的和

    大家好，我在不同的讨论中没有找到我的答案，希望大家能够帮助我。我有一个智能表，有两列:零件编号数量我想计算零件的总数与一定的数字。最后，当P/N等于某一值时，它是数量的加法。我…