工作分解结构(WBS) -列式公式配置

卡洛斯·蒙特斯

@Luis Salguero<\/a> Hi Luis! Great question. This formula takes into consideration the "Finish" (date) column and the "Task Duration Health Workdays" Sheet Summary field when assigning a color to the Health field. If you'd like to continue using both of these fields, the best way to interact with this formula is to enter the appropriate Start and Finish dates and then assign a number to the "Task Duration Health Workdays" field. <\/p>

The "Task Duration Health Workdays" field is a field you can edit. Currently, the number 4 is there. This means that when the Finish date is within 4 days and<\/em> the task is still not complete, we turn the health Yellow. This allows us to give a heads-up that a task is at risk of being late, instead of turning it from Green to Red with no warning. Some folks might like a 7 day notice, some prefer 1 day. I hope this answers your question!<\/p>","bodyRaw":"[{\"insert\":{\"mention\":{\"name\":\"Luis Salguero\",\"userID\":135536}}},{\"insert\":\" Hi Luis! Great question. This formula takes into consideration the \\\"Finish\\\" (date) column and the \\\"Task Duration Health Workdays\\\" Sheet Summary field when assigning a color to the Health field. If you'd like to continue using both of these fields, the best way to interact with this formula is to enter the appropriate Start and Finish dates and then assign a number to the \\\"Task Duration Health Workdays\\\" field. \\nThe \\\"Task Duration Health Workdays\\\" field is a field you can edit. Currently, the number 4 is there. This means that when the Finish date is within 4 days \"},{\"attributes\":{\"italic\":true},\"insert\":\"and\"},{\"insert\":\" the task is still not complete, we turn the health Yellow. This allows us to give a heads-up that a task is at risk of being late, instead of turning it from Green to Red with no warning. Some folks might like a 7 day notice, some prefer 1 day. I hope this answers your question!\\n\"}]","format":"rich","dateInserted":"2021-08-12T15:04:44+00:00","insertUser":{"userID":122600,"name":"Lea Gikas","url":"https:\/\/community.smartsheet.com\/profile\/Lea%20Gikas","photoUrl":"https:\/\/lh4.googleusercontent.com\/-P4eM3jbLOKc\/AAAAAAAAAAI\/AAAAAAAAAd8\/i4d67_a5Wgc\/photo.jpg","dateLastActive":"2022-09-07T13:49:30+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/301216#Comment_301216","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/301216#Comment_301216

嗨，Lea，谢谢你的澄清，我仍然有一个快速的问题。我如何编辑“任务持续时间健康工作日”，而不是4到7个。我试过了，没有隐藏的列，即使公式指向那个字段，我怎么能改变它?谢谢，谢谢

桑德拉Wlasiewicz

你好,

感谢团队为这个梦幻般的模板。我喜欢它，但它不能完全满足我的需求。我看到，当删除或缩进行时，后者的WBS编号会发生变化。由于我们使用这个WBS作为Case ID，因此重要的是，一旦分配了这些数字，就不要更改。你有什么快速的解决办法吗?

从本质上讲，我想使父WBS编号保持不变，当一行被删除之前，例如第6行和第7行-> 6被删除，7应该保持为7，而不是更改为6。缩进也是一样，如果我将第6行缩进为5.1，我希望第7行保持7，而不是改变为6。这可能吗?

这样，如果case ID被锁定，当有人按表中的任何列排序时，我应该让它们出现在正确的项目名称中。

谢谢你！：）