"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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!