Formula for a "Nested IF" formula for Status to change based on Percentage Complete number?

Marina Han

Hi there,

I'm looking for a way to automatically update the "status" cell based on the "% complete" number.

If % complete is:

0% or blank = "Not Started"

1-99% = "In Progress"

100% = "Complete"

Thanks in advance!

Kelly Moore

Hey @Marina Han

Oops. I confused which column was what. Change the references of Status@row to whatever your [% Complete] is called.

This formula will go in your Status column

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

Make sure to change the name of the column to match yours.

Kelly

Kelly Moore

Hey @Marina Han

Try this

=IF(OR(Status@row=0, ISBLANK(Status@row)), "Not Started", IF(Status@row<1, "In Progress", "Complete"))

cheers,

Kelly

Marina Han

Hi @KDM ! Thanks for your response. I am getting a "Circular Reference" error with your suggested formula. Can you please assist?

Kelly Moore

Hey @Marina Han

Oops. I confused which column was what. Change the references of Status@row to whatever your [% Complete] is called.

This formula will go in your Status column

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

Make sure to change the name of the column to match yours.

Kelly

Marina Han

That worked! Thanks very much, @KDM!