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.
Update a Status Column when % Complete
I have two columns in my Project Sheet which should always be in sync. I want my team to only update the "% Complete" column as they make progress on tasks, but I would like to see the "Status" column update automatically.
- If % Complete is = 0%, then Status should be "Not Started"
- If % Complete is > 0% AND < 100%, then Status should be "In Process"
- If % Complete is = 100%, then Status should be "Completed"
Would you help me define this?