Automatically update the status column when % complete is populated

  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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!