WBS Formula help

I am trying to join the WBS formula to include another level or substep

ID formula = IF([ID_Parent]@row <> "", [ID_Parent]@row, JOIN([ID_Child]:[ID_Child], ".", [Child_Count]@row))

I want the result to be WS1.1.2.1 instead of just displaying .1 under WS1.1.2

Find more posts tagged with

Accepted answers

All comments

Hi @Melissa Torrez,

Try this formula: =IF([ID_Parent]@row <> "", [ID_Parent]@row, PARENT([ID_Child]@row) + "." + [Child Count]@row)

This will fix your issue on the row you specified. I don't know what your formula is in the ID Child column, but if you can add an IF statement to pull in the ID_Parent in if ID_Parent is not blank, I think the ID column formula noted above will work.

I hope this helps!

www.linkedin.com/in/julie-fortney-pmp-lssblackbelt

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.