Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

  • Community Champion
    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.

    Kelly

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions