Primavera P6 Export To Excel And Color WBS Levels Automatically || How To Color WBS Levels

[@sayftaleb6020]

and that is a professional tutorial, thank you sir.

[@theanhnguyen1944]

That's great. Thank you for your sharing

[@dptutorials]

My pleasure

[@planneradebolaibraheem1168]

Thanks Bai the tutorial is great....very helpful.

[@pinakimajumdar3788]

Very useful. Thanks for sharing.

[@tahirhanif9669]

Thanks Bro, excellent!

[@dptutorials]

You're welcome!

[@brihoumrabah7135]

very helpful 👍🏻 thanks

[@scottlong7319]

Awesome, Now if there was nly a way to Auto outline without having to write a VBA script!

[@sucreelbarbaro2138]

Nice! Thank you!

[@dptutorials]

Thank you too!

[@clive5390]

Thank you very much

[@ApoorvaDixit1488]

Thank you for this very useful trick.

[@dptutorials]

Thanks a lot for the feedback. I welcome you to subscribe to this channel to enjoy more interesting videos

[@ahmadyassin1089]

thank you sir.. very helpful

[@dptutorials]

You are so welcome.

[@marklafke]

Excelent!!

[@dptutorials]

Thanks a lot

[@JadenExoticsAndBullies23]

Thank You

[@dptutorials]

You're welcome

[@dongmikevlog681]

Nice video thank you.

[@dptutorials]

Thanks a lot...

[@angkhoaphan2429]

great

[@dptutorials]

Most welcome

[@hareshjayanth1119]

Amazing

[@dptutorials]

Thanks a lot.

[@chizlmnizl2806]

Colouring formula not working, what comes after =AND($A1=0,$C1= ?

[@babatundeokunola3014]

thanks for sharing this tutorial. However, i noticed that formula "=((FIND(TRIM(B3),B3)-1))/2" does not work beyond level 9. What formula could be used you if you have breakdown beyond 9?

[@dptutorials]

Let me check, can u please mail me your document at [e-mail]

[@carlodigma5128]

iT IS OK BUT WHEN PROCEED TO ANOTHER NOT COMING AND WHEN 1 IS SELECTED ONLY ONE ROW COMING PLEASE GUIDE THANKS.

[@baqiyatullah4065]

Helo dear When I export my project to pdf then if three WBS then it goes three pages and if 5 wBS then 5 pages are printed. Please anyone guide me how I print these wBS on one page??????🙏🙏🙏🙏🙏🙏🙏🙏

[@s_an2011]

why did use trim with subtract one divide 2 ? and why did you put and in the second formula ?

[@dptutorials]

TO REMOVE THE SPACES.

[@ssarkar2006india]

Good

[@dptutorials]

Thank you, I welcome you to subscribe to this channel to enjoy more interesting videos. Reply ·

[@AbhishekSingh.051]

I was trying this...but it was not working

[@abrakadabra9111]

=((FIND(MID(B2,FIND(MID(TRIM(B2),1,1),B2),LEN(B2)),B2))-1)/2

[@asirijayawickrama7348]

@@abrakadabra9111 THANKS A LOT IT WORKED...THAT COLOURING FORMULA IS ALSO NOT WORKING...COULD YOU PLEASE HELP?..

[@davidasemota]

@@asirijayawickrama7348 Same with me, Did you find the solution?

[@chouhanshantanu9]

More advance video please

[@Now-Wow]

Doesn't work

[@waheedislam3052]

Hi, thanks for your video. But i am facing problem while formatting for colours. Plz solve my query.. thanks

[@dptutorials]

Let me check

[@johnekenjoku5257]

After entering the formula, and hitting 2, the result doesn't give me 0. It's give an error

[@davidasemota]

I have the same problem. Pls have you been able to resolve it? Thanks!!

[@johnekenjoku5257]

@@davidasemota couldn't resolve it

[@learnanything-3506]

I need your support to do the same in reverse direction

[@dptutorials]

I didn't get you. Reverse means?

[@learnanything-3506]

@@dptutorials excel to Primavera import or copy & paste to P6

[@ckshankar3]

Sir, i cant make second type of level1, level 2 colouring pl guide

[@dptutorials]

The same thing is mentioned in the video.

[@zeke8554]

in PRAAIMAVERA P6

[@dptutorials]

Thank you.

[@terryathome]

There is no level 0 in Primavera, change the sum to +1 to correct

[@dptutorials]

Level 0 is for the project name.

[@sefarzadnia]

didnt work with me!!! returns#VALUE!

[@dptutorials]

Please follow the process as mentioned, if not please write to [e-mail] with your file.

[@abrakadabra9111]

=((FIND(MID(B2,FIND(MID(TRIM(B2),1,1),B2),LEN(B2)),B2))-1)/2

[@johnekenjoku5257]

Yea. Same issue I have. What could be the solution