#1
|
|||
|
|||
two week out notice
I would like to have a column that will show a visual alert for a item that is two weeks from finish and less than 50% complete I have written the formula below in Excell but cannot transfer to Project :
=IF(INT(C2-NOW()) <=14,IF(B2<=50,"R",IF(B2>50,IF(B2<76,"Y","G"))),"N A") I have attached the excell sheet as well Can this be done? Last edited by Normie; 09-30-2016 at 07:42 AM. Reason: File added |
#2
|
|||
|
|||
Formulas in Excel do not transfer to Project. Project formulas and functions are more closely aligned with Access.
What kind of "visual alert" are you needing? When you talk about two weeks from finish - what about tasks that are less than two weeks in duration and aren't supposed to be started? Have you considered looking at Finish variance which will show the difference in the baseline finish versus planned finish? |
#3
|
|||
|
|||
problem solved
I was able to get what I needed
TEXT 2 : [Finish]-NOW() TEXT 1 : IIf([Text2]<=14,IIf([% Complete]<=50,"R",IIf([% Complete]>50,IIf([% Complete]<76,"Y","G"))),"NA") and then used graphical Indicators |
#4
|
|||
|
|||
Nice job, Normie. Thanks for posting your solution.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Office update notice | RodG | Office | 4 | 12-09-2015 01:27 PM |
Footnote continuation notice | Ulodesk | Word | 2 | 09-29-2014 06:13 AM |
Week by week report | thedeadzeds | Excel | 3 | 11-16-2013 02:06 AM |
Outlook Removing PDF Attachments Without Any Notice. | lockflow | Outlook | 0 | 07-26-2012 08:19 PM |
5 days/week during planning & 7 days/week during implementation | sanlen | Project | 1 | 06-25-2012 04:17 PM |