|
|
#1
09-29-2016, 02:00 PM
|
|||
|
|||
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 
|
|
|
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 |
Windows 7 32bit 
Office 2007
Threaded Mode