Status and % Complete co-dependency formula

edited 12/09/19 in Formulas and Functions

Hi there,


I am trying to figure out how to get Smartsheet to automatically change "status" column to "Completed" when I enter 100% in the "Complete" column, as well as to "Started" when I enter any % higher than 0%, and to "Not Started" if the % is 0. Is there a way to do this? Thanks!






Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!