"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!