Home › Forums › Discussion › counting the number of predecessors › Reply To: counting the number of predecessors
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.
Please enter your username or email address. You will receive a link to create a new password via email.