Getting project to recognize the current date for my formulas


T

texmaster

Hi

Hope everyone had a great Thanksgiving break

Got a question about formulas

I use 2 that calculate both working days left and a status light

Working Days Left: IIf([% Wor
Complete]=100,0,ProjDateDiff([Finish],Date(),[Project Calendar])

Status Light: IIf([% Complete]=100,"Blue",IIf(ProjDateDiff([Curren
Date],[Finish],[Project Calendar])/480<0,"Red",IIf(ProjDateDiff([Curren
Date],[Finish],[Projec
Calendar])/480<5,"Yellow",IIf(ProjDateDiff([Curren
Date],[Finish],[Project Calendar])/480>=5,"Green")))

The problem is when I open the projects back up like today, projec
doesn't compensate for the time lost aka the working days left and th
status light are still pulling from the original date I created th
spreadsheet and not recognizing the current date in computing eithe
formula

What am I doing wrong here
 
Ad

Advertisements

J

JulieS

Hi texmaster,

I believe the difficulty is that Project does not recalculate a
project file on open. If you press F9 when you open the file, does
all work?

The other option is to try the Current Date field instead of the
Date() reference. I am not sure if Current Date automatically
recalculates.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project
 
J

JulieS

Okay, let's start again.

What version of MS Project, including service pack.

What types of fields have you entered the formulas in?
If you change the [Current date] in Project > Project information,
do the values in the stop light formula recalculate?

Julie
 
Ad

Advertisements

M

Mike Glen

Hi texmaster,

Try posting on the microsoft.public.project.developer newsgroup (forum). Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP



Hi!

Hope everyone had a great Thanksgiving break!

Got a question about formulas.

I use 2 that calculate both working days left and a status light.

Working Days Left: IIf([% Work
Complete]=100,0,ProjDateDiff([Finish],Date(),[Project Calendar]))

Status Light: IIf([% Complete]=100,"Blue",IIf(ProjDateDiff([Current
Date],[Finish],[Project Calendar])/480<0,"Red",IIf(ProjDateDiff([Current
Date],[Finish],[Project
Calendar])/480<5,"Yellow",IIf(ProjDateDiff([Current
Date],[Finish],[Project Calendar])/480>=5,"Green"))))

The problem is when I open the projects back up like today, project
doesn't compensate for the time lost aka the working days left and the
status light are still pulling from the original date I created the
spreadsheet and not recognizing the current date in computing either
formula.

What am I doing wrong here?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top