How to put a value for each item in dropdown list

I have a dropdown list and I want to put a value for each item (but not in the list):

Not Ordered = 0% complete

Ready to Order = 1% complete

Order Process = 20%

Shipped = 50% complete

In Country Customs = 80% complete

Delivered = 100% complete

Cancelled = 100% complete

This is to help me to calculate the task % complete for orveral project % complete

Thank you very much!


Thank you very much for any help!😉


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!