Need help editing "Status" formula so it doesn't automatically change to "In Progress"

Mary Farmer

Hi,

Hoping to get advice on how to edit the below formula. When the "Start" date becomes the current calendar date, the "Status" changes to "In Progress" even though the % Complete is still blank. I'd expect the status to remain "Not Started" (if the % Complete is blank or zero), and change to "Overdue" when the "Finish Date" passes (without being 100% complete).

Thanks,

Mary

Paul Newcome

Try moving "Not Started" to immediately after the first "In Progress" and ending the formula there.

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

Mary Farmer

Thank you!!! Perfect.

Paul Newcome

Try moving "Not Started" to immediately after the first "In Progress" and ending the formula there.

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

Mary Farmer

Thank you!!! Perfect.

Paul Newcome

Happy to help. 👍️