Khuong Do is a Project Planner / Construction Claims Consultant / Delay Analyst in Civil, Transportation and Oil & Gas Industry. He has worked as a Primavera Consultant Specialist since 2006 . He holds a Civil Engineering degree and a Bachelor of Information Management System. Now he is working in SGC company, providing Delay Analysis service. They have offices in Beijing – China and Dubai – UAE.
View all posts by Khuong Do

9 Comments

Hi!

We can also add WBS Path Column, and get the details of Level and Total Path.

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:

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