Change drop down cell to Complete if %=1, If not leave drop down cell at currnet value.

Bill Stadler

We have Project State pulldown column that consist of

 

Active

 

Complete

 

Future

 

Parked. 

 

 

 

We also have a %Complete Column.

 

 

 

Is there a way to set the Project State to Complete when the % = 1(100%) and leave it at the current value if the % <> 1? 

 

If there is a better method or sheet setup I am all ears.

 

Thanks!

 

 

J. Craig Williams

Bill,

 

If you use a formula, then you won't be able to manually update the Project State without losing your formula.

The only way to handle this is by completing coding the Project State.

 

The problem I typically circular work flows.

By this, I mean, if you can find something that says 'this is active because i have this check box checked and that task is not complete' 

 

Let's use an simple example:

My status is "new", "assigned", "later", "complete"

 

if % complete = 1 then

 status = complete

else if later checkbox is checked then

 status = later

else if assigned to has someone's name then

 status = assigned

else 

 status = new

 

works.

But the status is "later" whether there is someone assigned to it or not.

Which might make sense, might not.

Starts rapidly getting more complicated when you start adding status'.

And if I can, at some point in the process, be redirected to an earlier phase, it can easily fall apart.

 

Hope that is clear.

 

Craig