Loading...
Quick Links

Reply To: counting the number of predecessors

Home Forums Discussion counting the number of predecessors Reply To: counting the number of predecessors

#399027
Timothy JonesTim Jones
Guest

Following up on Larry’s suggestion of a VBA solution, here’s a possible first step:

Create a custom number field ([Number20] for this example) with the following formula: Len([Predecessors])

It will return the number of characters in the string from the predecessor field.

Then you can use a formula like the following and add graphical indicators to flag the pinch points with a RED stoplight indicator:

Switch([Number20]<10,”GREEN”,[Number20]>=10 And [Number20]<=20,”YELLOW”,[Number20]>20,”RED”)

You can adjust the formula depending on the number of lines in your schedule.