Formulas and Graphical Indicators

Home Forums Customization Forum Formulas and Graphical Indicators

Viewing 7 reply threads
  • Author
    Posts
    • #114162
      Ron
      Guest

      How to create formulas & stop light indicators based on % complete & start and finish dates. What I need is:
      BLUE if % complete is 100%
      GREEN if % complete is 99%
      YELLOW if % complete is > 0 (started) and between start and finish dates
      CLEAR if current date prior to scheduled start date
      RED if % complete = 0 and current date is > or = start date (prefer to compare to pro-rated completion % between start and finish date but not sure how to do this without getting too complex)
      RED if % complete < 99% and current date > finish date

    • #114169
      Avatar photoCommunity
      Keymaster

      Hi Ron,

      Check out our Custom Formula guide, I think it is just what you’re looking for 🙂
      https://www.mpug.com/wp-content/uploads/2013/12/Customization-Formula-Guide-PDF-Version.pdf

    • #409806
      Avatar photoRobert Liess
      Member

      Hi all,

      I am trying to add graphic indicators to my project plan following the instructions from the “ProjectWebv5.ppt” from Doug Bonebrake.

      MS Project doesn’t let me insert the warning formula `IIf([% Complete]<100,Switch(([Number3]
      <-5),3,[Number3]>=-5 And [Number3]<0,2,[Number3]>=0,1),3)` . I get a syntax error for the function “Switch”. Does anyone have an idea how to fix this?

    • #409906
      Avatar photoJohn Riopel
      Participant

      I tried this and it worked for me. IIf([% Complete]<100,Switch(([Number3]<-5),3,[Number3]>=-5 And [Number3]<0,2,[Number3]>=0,1),3)

    • #409908
      Avatar photoRobert Liess
      Member

      Thanks John for testing. That’s strange. I can’t get this formula working in my MS Project 2010.

    • #475343
      Arumalor
      Guest

      Book taxi to Brussels Airport (BRU). Comfortable taxi transfer to / from Brussels Airport. AtoB airport taxi will comfortably take you anywhere in Belgium.
      https://atobtransfer.com/brussels-belgium/atob-taxi-to-brussels-airport/
      https://www.facebook.com/transferservicebrussels/
      https://twitter.com/AtoB_transfer_

    • #483213
      Anonymous
      Inactive

      100% Pass Rate Guaranteed PMP certificate without exam in Saudi Arabia Buypmpwithoutexams@yahoo.com | Buy PMP certificate without exam Italy | Buy PMP certificate without exam in Switzerland | Buy PMP certificate without exam in the Netherlands | Buy PMP certificate without exam in Pologne | Buy PMP certificate without exam in the United Kingdom | Buy PMP certificate without exam in Turkey | Buy PMP certificate without exam in Spain | Buy PMP certificate without exam in Spain | Buy PMP certificate without exam in Russia

      info@buypmpwithoutexams.com

      Whats-app +16575292372

      Skype-ID (PMP Exam Questions)

      https://www.buypmpwithoutexams.com

      https://pmpcertification.ning.com/

      https://5fd5443a95e84.site123.me

    • #484608
      Anonymous
      Inactive

      MaxBet Casino online: jocuri & pacanele online, blackjack, sloturi online.
      https://www.maxbet.ro

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