Manual Override a formula

[Mat]

Hi guys
Ive got a RAG status formula that represents late tasks with a red graphical
indicator, Baseline slippage with amber etc and I need to put some sort of
manual override in so that I can force a status not based on the formula - im
sure ive seen it done before can anyone help ?
I need to sort this quite quick so all input appreciated.
Here's the formula

IIf([Finish]<Now() And [% Complete]<100,1,IIf([Start]<Now() And [%
Complete]=0,1,IIf([Finish]>[Baseline Finish] And [%
Complete]<100,2,IIf([Finish]=[Baseline Finish] And [% Complete]<100,3,IIf([%
Complete]=100,4,3)))))

Cheers

Mat

 

[Jan De Messemaeker]

Hi,

You can put any Flag field manually to Yes and take that into account in
your formula.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Jim Aksel]

If the field is set to calculate a formula there is no way to override it
allowing a manual entry. As Jan suggested, you can add as many conditions
are you wish with the Flag fields or other fields. In doing so, your new
formula will automatically calculate based on the flag field the same way
every time. In short, every conditin must be specified in the formula.

Perhaps another field can be used with a graphical indicator that allows
manual entry.
--
If this post was helpful, please consider rating it.

Jim

Check out my new blog for more information:
http://www.msprojectblog.com

 

[Mat]

Hi thanks for this - can you expand on how the formula will look then ?

im struggling

Hi,

You can put any Flag field manually to Yes and take that into account in
your formula.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Hi guys
Ive got a RAG status formula that represents late tasks with a red
graphical
indicator, Baseline slippage with amber etc and I need to put some sort of
manual override in so that I can force a status not based on the formula -
im
sure ive seen it done before can anyone help ?
I need to sort this quite quick so all input appreciated.
Here's the formula

IIf([Finish]<Now() And [% Complete]<100,1,IIf([Start]<Now() And [%
Complete]=0,1,IIf([Finish]>[Baseline Finish] And [%
Complete]<100,2,IIf([Finish]=[Baseline Finish] And [%
Complete]<100,3,IIf([%
Complete]=100,4,3)))))

Cheers

Mat

 

[Jan De Messemaeker]

HI,

Iif([Flag7],Yes,(your current formula))

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Hi thanks for this - can you expand on how the formula will look then ?

im struggling

Hi,

You can put any Flag field manually to Yes and take that into account in
your formula.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Hi guys
Ive got a RAG status formula that represents late tasks with a red
graphical
indicator, Baseline slippage with amber etc and I need to put some sort
of
manual override in so that I can force a status not based on the
formula -
im
sure ive seen it done before can anyone help ?
I need to sort this quite quick so all input appreciated.
Here's the formula

IIf([Finish]<Now() And [% Complete]<100,1,IIf([Start]<Now() And [%
Complete]=0,1,IIf([Finish]>[Baseline Finish] And [%
Complete]<100,2,IIf([Finish]=[Baseline Finish] And [%
Complete]<100,3,IIf([%
Complete]=100,4,3)))))

Cheers

Mat