Kirragirl Posted July 26, 2011 Share Posted July 26, 2011 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)))) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now