Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Change drop down cell to Complete if %=1, If not leave drop down cell at currnet value.
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!
Comments
-
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
-
Yes. Very clear.. I hoping I was missing something.
Thank you.
