"IF" Formula Question with Symbol

JbrownHOA

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?

Carson Penticuff

Give this a try:

=IF(ISBLANK([% Complete]@row, "", IF([% Complete]@row = 1, "Full", IF([% Complete]@row = 0.5, "Half", IF([% Complete]@row = 0, "Empty", ""))))

JbrownHOA

Thanks, but unfortunately it didn't work. It's saying "incorrect argument set" after I put that equation in.

Carson Penticuff

Yup, I can see why it wouldn't…. I missed a closing paren. See if this works instead. 😁

=IF(ISBLANK([% Complete]@row), "", IF([% Complete]@row = 1, "Full", IF([% Complete]@row = 0.5, "Half", IF([% Complete]@row = 0, "Empty", ""))))