Question on how to create a percentage complete formula based on a status drop down menu


I need help creating a percentage complete formula for a Due Diligence Checklist that I am working on. The status drop down menu completion option is "satisfactory". Can anyone help? If you need more information, please let me know.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!