Autofill "% Complete" column based on "Status" column

I'm trying to make it so that when I select "Complete" in the status column that the "% Complete" column auto fills to "100%". Any help would be greatly appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!