"IF" Formula Question with Symbol


Hi, I'm trying to write an equation so that my "% Complete" Column tells my "Progress" column to either be an empty circle symbol, a half circle symbol or a full circle symbol. There are only 3 options in the % Complete column: 0%, 50% and 100%. But I can't get anything to work for my Progress column outcome. See attached. Can anyone help me out?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!