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))))
Welcome to MSFN ForumRegister 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
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users