Jump to content
Strawberry Orange Banana Lime Leaf Slate Sky Blueberry Grape Watermelon Chocolate Marble
Strawberry Orange Banana Lime Leaf Slate Sky Blueberry Grape Watermelon Chocolate Marble

MSFN is made available via donations, subscriptions and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. Alternatively, register and become a site sponsor/subscriber and ads will be disabled automatically. 

Sign in to follow this  
Kirragirl

MS Project Custom Field with Formula

Recommended Posts

Kirragirl    0

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))))

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×