After export activity table from Primavera P6 to Excel, it’s very hard to tell this activity belong to what WBS.
We can add 1 column to show the WBS level for each activity.
The formula for the column is : =((FIND(TRIM(B2),B2))-1)/2
Apply to the rest so we can see WBS level for each activity:
Hi!
We can also add WBS Path Column, and get the details of Level and Total Path.
Thanks,
Jigar Shah
LikeLiked by 1 person
I’m using similar formula : =FIND(LEFT(TRIM(K6)),K6)
LikeLiked by 1 person
Hi all,
Thanks for your sharing.
LikeLike
Hi all,
can anyone help me?
very strange..excel gives out formula issue as follow:
We found a problem with this formula. Try clicking Insert Function on the Formulas tab to fix it, or click Help for more info on common formula problems.
Not trying to type a formula?
When the first character is an equal (=) or minus (-) sign, Excel thinks it`s a formula:
you type =1+1, cell shows : 2
To get arround this, type an apostrophe (`) first:
you type: `=1+1, cell shows =1+1
Thanks
LikeLike
Hi all, how can i apply the formula to the rest of the tasks after the first row?
LikeLike
Simply, you can drag it to the rest of rows, or copy & paste
LikeLike
=((FIND(TRIM(B2),B2))-1)/2 why (/2) ??
and can we use =((FIND(TRIM(B2),B2))-1) only
thanks in advance
LikeLike
Hi. Because each WBS Level is distinguish by 2 space.
LikeLike
Hi all,
Check out my sheet with same P6 coloring codes
LikeLiked by 1 person
That’s great!
LikeLiked by 1 person