Oracle Primavera - PM6 Member for 2 years 8 months Member for 2 years 8 months Submitted by John Deere on Fri, 2024-08-16 20:15 Permalink Hello Zoltan,I'm using this Hello Zoltan, I'm using this formula to count the number of spaces at the beginning of each lines. Then I use conditionnal formatting to color the lines based on the number of spaces. The formula is unfortunately in french, hope this helps though. =TROUVE(GAUCHE(SUPPRESPACE(D10),1),D10)-1 The English version should be: =find(left(trim(D10),1),D10)-1 Regards, Jean Member for 2 years 8 months Member for 2 years 8 months Submitted by John Deere on Fri, 2024-08-16 20:14 Permalink Hello Zoltan,I'm using this Hello Zoltan, I'm using this formula to count the number of spaces at the beginning of each lines. Then I use conditionnal formatting to color the lines based on the number of spaces. The formula is unfortunately in french, hope this helps though. =TROUVE(GAUCHE(SUPPRESPACE(D10),1),D10)-1 The English version should be: =find(left(trim(D10),1),D10)-1 Regards, Jean Member for 5 years 9 months Member for 5 years 9 months Submitted by theglitter on Wed, 2024-08-14 21:54 Permalink Thank you Zoltan. I usually Thank you Zoltan. I usually have a spreadsheet ready with a formula (that trims and detects the WBS level/activity) and conditionnal formatting that colors the WBS rows using P6 default color pallette. But a plugin would help to automate things better. Log in or register to post comments
Member for 2 years 8 months Member for 2 years 8 months Submitted by John Deere on Fri, 2024-08-16 20:15 Permalink Hello Zoltan,I'm using this Hello Zoltan, I'm using this formula to count the number of spaces at the beginning of each lines. Then I use conditionnal formatting to color the lines based on the number of spaces. The formula is unfortunately in french, hope this helps though. =TROUVE(GAUCHE(SUPPRESPACE(D10),1),D10)-1 The English version should be: =find(left(trim(D10),1),D10)-1 Regards, Jean
Member for 2 years 8 months Member for 2 years 8 months Submitted by John Deere on Fri, 2024-08-16 20:14 Permalink Hello Zoltan,I'm using this Hello Zoltan, I'm using this formula to count the number of spaces at the beginning of each lines. Then I use conditionnal formatting to color the lines based on the number of spaces. The formula is unfortunately in french, hope this helps though. =TROUVE(GAUCHE(SUPPRESPACE(D10),1),D10)-1 The English version should be: =find(left(trim(D10),1),D10)-1 Regards, Jean
Member for 5 years 9 months Member for 5 years 9 months Submitted by theglitter on Wed, 2024-08-14 21:54 Permalink Thank you Zoltan. I usually Thank you Zoltan. I usually have a spreadsheet ready with a formula (that trims and detects the WBS level/activity) and conditionnal formatting that colors the WBS rows using P6 default color pallette. But a plugin would help to automate things better.
Member for
2 years 8 monthsHello Zoltan,I'm using this
Hello Zoltan,
I'm using this formula to count the number of spaces at the beginning of each lines.
Then I use conditionnal formatting to color the lines based on the number of spaces.
The formula is unfortunately in french, hope this helps though.
=TROUVE(GAUCHE(SUPPRESPACE(D10),1),D10)-1
The English version should be:
=find(left(trim(D10),1),D10)-1
Regards, Jean
Member for
2 years 8 monthsHello Zoltan,I'm using this
Hello Zoltan,
I'm using this formula to count the number of spaces at the beginning of each lines.
Then I use conditionnal formatting to color the lines based on the number of spaces.
The formula is unfortunately in french, hope this helps though.
=TROUVE(GAUCHE(SUPPRESPACE(D10),1),D10)-1
The English version should be:
=find(left(trim(D10),1),D10)-1
Regards, Jean
Member for
5 years 9 monthsThank you Zoltan. I usually
Thank you Zoltan.
I usually have a spreadsheet ready with a formula (that trims and detects the WBS level/activity) and conditionnal formatting that colors the WBS rows using P6 default color pallette. But a plugin would help to automate things better.