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.

Bill Stadler
Bill Stadler ✭✭
edited 12/09/19 in Archived 2017 Posts

We have Project State pulldown column that consist of












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.






  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 01/27/17



    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


     status = new



    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.



  • Bill Stadler

    Yes.  Very clear..  I hoping I was missing something. 


    Thank you. 

This discussion has been closed.