Automatically update the status column when % complete is populated

ModupeT

1. If % Complete is 0%, Status should be Not Started
2. If % Complete is 100%, Status should be Complete
3. If % Complete is between 1% and 99%, Status is In Progress

heyjay

=IF([% Complete]@row = 0, "Not Started",
 IF([% Complete]@row = 1, "Complete", 
"Status in Porgress"))

ModupeT

Thank you for answering, but unfortunately this doesn't work.

Andrée Starå

Hi @ModupeT

I hope you're well and safe!

Do you get an error message?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

BraylenStanton

You can use conditional formatting in your application or spreadsheet program to automatically update the status column based on the percentage of completion of a task: If the % complete is 0%, the status will be "Not Started." If % completed is 100%, the status will be "Completed". If the % complete is between 1% and 99%, the status will be "In Progress".