Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-29-2016, 02:00 PM
Normie Normie is offline two week out notice Windows 7 32bit two week out notice Office 2007
Novice
two week out notice
 
Join Date: Nov 2015
Posts: 14
Normie is on a distinguished road
Default 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?
Attached Files
File Type: xlsx Status formula.xlsx (12.7 KB, 11 views)

Last edited by Normie; 09-30-2016 at 07:42 AM. Reason: File added
Reply With Quote
  #2  
Old 10-03-2016, 07:04 AM
JulieS JulieS is offline two week out notice Windows 7 64bit two week out notice Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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?
Reply With Quote
  #3  
Old 10-03-2016, 07:45 AM
Normie Normie is offline two week out notice Windows 7 32bit two week out notice Office 2007
Novice
two week out notice
 
Join Date: Nov 2015
Posts: 14
Normie is on a distinguished road
Default 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
Reply With Quote
  #4  
Old 10-03-2016, 08:16 AM
JulieS JulieS is offline two week out notice Windows 7 64bit two week out notice Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Nice job, Normie. Thanks for posting your solution.
Reply With Quote
Reply

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
two week out notice Footnote continuation notice Ulodesk Word 2 09-29-2014 06:13 AM
two week out notice 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
two week out notice 5 days/week during planning & 7 days/week during implementation sanlen Project 1 06-25-2012 04:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft