#### 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.

# Automated task status in a project plan

edited 12/09/19

I am building a project plan and would like to have the "Status" to be automated based on the % a team member fills in for a task.  I've tried several of the IF OR and IFAND statements and they work partly.  I can get the "Complete" and the "Not Started" to work but unable to figure out the "In Progress".  When I try to nest the "In Progress" I get an error message.  Here is the logic I would like to use:

If % Complete equals 0, “Not Started”, or if % Complete equals 100, “Complete”, or if % Complete < 100 and > 0, “In Progress”

Any suggestions??

• ✭✭✭✭✭✭

Try this formula. It should work for you. It will give you the result of "Not Started" if the % complete column is blank or has a 0. And then will give you the result of Complete if the % Complete is 100% which is really the number 1 in columns that are styled with the percent icon from the left menu. And then if any other value is in the field it will say in progress.

=IF(OR([% Complete]6 = 0, ISBLANK([% Complete]6)), "Not Started", IF([% Complete]6 = 1, "Complete", "In Progress"))

Hope that helps!

• ✭✭✭✭✭✭

=if([% Complete]6 = 1,"Complete",if(OR([% Complete]6 = 0,[% Complete]6 = ""),"Not Started","In Progress")

• that may work as well

=IF(ISBLANK([% Complete]1), "", IF([% Complete]1 = 0, "Not Started", IF([% Complete]1 = 1, "Completed", "In Progress")))

• edited 07/14/17

Worked perfectly...thank you!

• ✭✭✭✭✭✭

You're welcome! Glad to be of help.

This discussion has been closed.