Results 1 to 2 of 2

Thread: microsoft project formula question

  1. #1
    Join Date
    Sep 2010
    Posts
    1

    microsoft project formula question

    IIf([% complete]=0 and [Start]<[current Date],2,1)

    The above forumla works but what i would like to do is have more than a true or false option (2,1 as above)

    Basically i'm looking to write a formula that will.....

    Put a "1" in a text column if the% complete is greater than 0

    Put a "2" in a text column if the task is up to a week late in starting i.e the percent complete has a value of 0 and the date is 5 working days past today's date

    Put a "3" in a text column if the task is more than a week late in starting i.e the percent complete has a value of 0 and the date is greater than 5 working days past today's date.

    I have not included any way of measuring expectted progress compared to actual progress to date (its a v simple planning we're working in here)

    Please help!

  2. #2
    Join Date
    Nov 2008
    Posts
    1,185

    Re: microsoft project formula question

    Here I have one example of formula which may be helpful to solve your issue.

    IIf([% Complete]<100,Switch(([% Complete]=0 And (DateValue([Current Date])-DateValue([Start]))>0),1,((DateValue([Current Date])-DateValue([Finish]))<-5),3,(DateValue([Current Date])-DateValue([Finish]))>=-5 And (DateValue([Current Date])-DateValue([Finish]))<0,2,(DateValue([Current Date])-DateValue([Finish]))>=0,1),3)


    Just try this and let me know if this will solve your problem.

Similar Threads

  1. MS project formula's syntax and example
    By Amichait in forum Microsoft Project
    Replies: 1
    Last Post: 11-11-2011, 04:40 PM
  2. MS Project Formula
    By ConfusedProjectUser in forum Microsoft Project
    Replies: 1
    Last Post: 30-04-2011, 03:42 AM
  3. MSP custom field formula to track project progress
    By M0m1 in forum Microsoft Project
    Replies: 1
    Last Post: 30-04-2011, 03:40 AM
  4. Microsoft project formula again
    By smtamblyn in forum Windows Software
    Replies: 1
    Last Post: 19-02-2009, 04:51 PM
  5. Microsoft Project Formula
    By smtamblyn in forum Windows Software
    Replies: 2
    Last Post: 18-02-2009, 02:47 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,628,287.92242 seconds with 17 queries