I want to create a custum text column that will visually show if a tasks finish dates have been slipping or not by comparing Forecast Finish(Finish) to previous Months Finish (Finish1) and to Last weeks Finish(Finish2).
My thoughts were to use the IIF function in MS project to indicate the following:
Finish>Finish1(previous months finish) & >Finish2 (Previous Weeks Finish) = "> >". The first > signifies the task slipped compared to the previous month and the second > signifies that the task has continued to slipped compared to the previous weeks finish date.
Finish < Finish1, < Finish2 = "< <" ----Indicates the task has been moving to complete earlier
Finish > Finish1, <Finish2 = "> <" -----Indicates the task slipped from last month but is being pulled back in
Finish = Finish1, >Finish2 = "= >" -----Indicates that the task had no change from last month but slipped from last week
ETC..........
I have been trying the create the formula for this but for some reason I keep getting and error. Is anyone up to the challenge??
WELL DONE - Thank You
WELL DONE - Thank You
Hi David,
You need nested IIF Statements. The outline nested IIF is:
IIf( Exp1, Ans1, IIf( Exp2, Ans2, IIf( Exp3, Ans3, IIf( Exp4, Ans4, IIf( Exp5, Ans5, IIf( Exp6, Ans6, IIf( Exp7, Ans7, "= =" ) ) ) ) ) ) )
Replace the following in the above outline.
I think I have covered all possible 8 scenarios for you. See snippet below for working proof.
[[wysiwyg_imageupload:3213:]]
[[wysiwyg_imageupload:3214:]]