Is there a formula to update the status based off the % complete?

Deb Wardlaw

i.e % Complete is = to 0% then Status should equal not started, if % complete is > 0%, then status should be In Progress, if % complete is = to 100% then the status should equal Complete

Isis Taylor

@Deb Wardlaw Try this,

=IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 100, "Complete", IF([% Complete]@row > 0, "In Progress")))

Isis Taylor

@Deb Wardlaw Try this,

=IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 100, "Complete", IF([% Complete]@row > 0, "In Progress")))

Deb Wardlaw

Thank you that worked!