"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?
Answers

Give this a try:
=IF(ISBLANK([% Complete]@row, "", IF([% Complete]@row = 1, "Full", IF([% Complete]@row = 0.5, "Half", IF([% Complete]@row = 0, "Empty", ""))))

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

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", ""))))
Help Article Resources
Categories
Check out the Formula Handbook template!