"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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!