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

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!

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!