Work Breakdown Structure (WBS) - Column Formula Configuration

Carlos Montes

@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

Hi Lea, thks for your clarifications, i still have a quick Q. How could i edit, the "Task Duration Health Workdays" instead of 4 to 7 for example. I tried and there is no hidden column with that, even though the formula points to that field, how can i change it?, thks appreciated

Sandra Wlasiewicz

Hi All,

Thanks to the team for this fantastic template. I love it but it doesn't fully cover my needs. I saw that when rows are deleted or indented the latter WBS number changes. Since we are using this WBS as the Case ID, it's important that the numbers don't change once assigned. Do you have any quick fix for that?

Essentially I want to make the parent WBS numbering to stay the same when a row before it gets deleted, e.g. row 6 and 7 -> 6 gets deleted, 7 should stay as 7 and not change to 6. The same with indentation, if I indent row 6 to become 5.1 I want 7 to remain 7 and not change to 6. Is it possible?

This way if the case ID is locked I should have them appear for the correct project name when someone sorts by any column in the sheet.

Thank you! :)