Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

A Formula Request 2

Status
Not open for further replies.

Planner18

IS-IT--Management
Oct 27, 2014
19
US
Hi All,

I'm looking for a formula that will change graphical indicators before 'todays date' with the following outcome.

10 days or more before todays date = green
10 to 6 days before todays date = amber
5 days or less before todays date = red
100% complete = blue.

I hope I have explained this correctly and it is not unusual request as this formula may have been provided previously.

Any help will be gratefully received.

Many thanks
 
What is 10 days or more before today's date - the start date? the finish date?

switch([% Complete]=100,"blue",ProjDateDiff([Current Date],[Finish])/[Minutes Per Day]<=5,"red",ProjDateDiff([Current Date],[Finish])/[Minutes Per Day]<=10,"amber",ProjDateDiff([Current Date],[Finish])/[Minutes Per Day]>10,"green")

The formula uses the finish date. It will return the words for the color - then use the graphic indicators to shows the colors based upon the text returned.
 
Thank you for your response. It is much appreciated.
 
Hi Julie,

I'm new to the forum and don't know if you could help.

I have a similar request to Planner18. I need a formula to be able compare the movement of two finish dates. For example;

If task = 100% Complete then 0
If finish date is greater than finish1 date then 1
If finish date is less than finish1 date then 2
If finish date is equal to finish date then 3
If either finish date or finish1 date is 'NA' then leave blank.

I could then add indicators to show the movement.

I hope this makes sense and would be really grateful if you know the formula that could produce this outcome or point me to someone who can.

Many thanks

Gogglebox
 
HI Gogglebox,

Welcome to Tek-Tips.

What you would do here is post your question in a new thread. This thread is ONLT to address the question(s) of the original poster.

Look forward to seeing your question posted in a new thread.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Hi SkipVought,

Apologies, I was trying to keep the same theme going.

I will post a new thread.

Thanks

Gogglebox
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top