"IF" Formula Question with Symbol

Options

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?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!