counting the number of predecessors

Home Forums Microsoft Project Discussion Forum counting the number of predecessors

  • This topic is empty.
Viewing 11 reply threads
  • Author
    Posts
    • #398928
      tallulah
      Guest

      Hello

      I am looking to find a way to use a graphical indicator to show those projects with high numbers of predecessors or successors as I want to be able to easily spot pinch points; but I cant figure out the formula.

      Can anyone help?

    • #398939
      Avatar photoLarry Christofaro
      Participant

      First obvious question, are you using Project Server and do you want to see that at the project level? If so you can with a bit of knowledge (not technical). You will also need a defined formula more than “high numbers”. I can lay out a description if I’m on the right track.

      • #398984
        Tallulah
        Guest

        Thanks for the offer of support!!!! Im using a stand alone MS project 2010. Ive lots of projects listed, each with numerous tasks underneath and Im using this to monitor all the interdependencies etc and the overall portfolio timeline. This is working well. There are many tasks though that have high numbers of predecessors or successors and I want to be able to use a graphical indicator in a custom field to pick out those activities with more than, say 8 predecessors as red or more than 5 as amber. Same for successors. Im new to project though and this formula defeats me.

        Very grateful for any support

    • #398994
      Avatar photoLarry Christofaro
      Participant

      That makes sense. You might be able to do this using VBA but nothing out of the box. I’m not the VBA expert but hopefully someone can answer this better for you.

    • #399027
      Avatar photoTim 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.

    • #399028
      Avatar photoTim Jones
      Guest

      The formula and graphical indicators are in a separate custom text field.

    • #399031
      Avatar photoLarry Christofaro
      Participant

      Creative…I like it!!

    • #399072
      Tallulah
      Guest

      That totally works – you are amazing!!! Thank you so much xxx

    • #408815
      Avatar photoTim Jones
      Guest

      Update: This formula is better than the Len([Predecessors]) formula from my initial reply:

      IIf(LEN([Predecessors])>0,LEN([Predecessors])-LEN(REPLACE([Predecessors],”,”,””))+1,0)

      The Len([Predecessors]) formula returns a count that includes the commas in the string; the new formula removes the commas, adds “1” (because there will be one more predecessor than there are commas), and then takes the difference, returning the exact number of predecessors.

      I’m updating this so long after the original post because I recently had a need to use this formula and did a little more searching to find a way to get the exact number of predecessors:)

    • #409733
      Tony K
      Guest

      Tim, thanks for sharing the formula(s) above. Everything works perfectly except the formula you posted on 2/10/2017. Is there something missing from that formula? Any guidance you can provide would be great. Thank you

    • #410202
      James Martin
      Member

      Using Project Pro 2013 stand alone. My solution took me down this path & revised formula.

      IIf(LEN([Predecessors])>0;LEN([Predecessors])-LEN(REPLACE([Predecessors];’;’;”))+1;0)

      Try that one… It appears to be a syntax issue, replace comma with semi colon and double quotes with single quotes. Original logic is correct.

    • #410269
      Avatar photoTimothy Jones
      Participant

      Thanks James – looks like a difference between 2013 and 2010 (I’m using 2010 stand alone).

      Tony – Sorry I didn’t see this when you posted – hope you have it working now.

    • #413297
      Minerva Goree
      Guest

      Below is the formula that worked for me. I’m using MSP Server 2016.

      IIf(LEN([Predecessors])>0,LEN([Predecessors])-LEN(REPLACE([Predecessors],',',""))+1,0)

Viewing 11 reply threads
  • You must be logged in to reply to this topic.