Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account


MS Project Custom Field with Formula

- - - - -

  • Please log in to reply
No replies to this topic


  • Member
  • 1 posts
  • Joined 25-July 11
  • OS:Windows 7 x64
  • Country: Country Flag
I have developed the formula shown below for a colleague's schedule to indicate Red, Amber, Green status. This colleague now wishes for me to add to the graphical indicators a Tick to represent Completed Tasks and a Cross to indicate those Tasks whereby the Work column has been amended to 0 to reflect the task is Cancelled. Could someone help me in amending/revising this formula?

IIf([Scheduled Duration]=0,(IIf([% Complete]=100,2,IIf([Scheduled Finish]<Now()+7 And [% Complete]<100 And [% Complete]>=80,3,IIf([Scheduled Finish]<Now()+7 And [% Complete]<80,4,1)))),IIf(([% Complete]=100 Or [% Complete]>100*(Abs((Now()-[Scheduled Start])/([Scheduled Finish]-[Scheduled Start])))),2,(IIf([Scheduled Finish]>Now(),IIf([Scheduled Start]>Now(),1,3),4))))

How to remove advertisement from MSFN

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users