Creating a formula with a drop down box of percentages


Hello All,

I am working on using a drop down box to calculate task percentage as well as the complete percentage total per phase. Initially we were using the % Complete and allowing any percentage to be entered however now we are going with a set percentage to make it easier on the client. The problem is that now when I use the same formula it calculates 100 regardless of what the drop down box selection is.

The choices are in 25% increments. I am not sure what I am doing wrong. There are 38 tasks within Phase I and no matter what I change the drop down selection to the answer is always 100%.

25%*2 should be 50% or is my math off? Any feedback would be very helpful.

-Kind Regards

Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!