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 in Archived 2017 Posts

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??


Task Status Formula.png


This discussion has been closed.