Trying to Input a formula to automatically generate a symbol
I have a column where I am tracking percent met and I want that percent to trigger a symbol in the column next to it. The symbols I am using are the 5 circles (Empty, Quarter, Half, Three Quarter, Full). This is the code I tried
=IF([Percent Met]3, =100, "Full", IF([Percent Met]3, 99.9 > 75 "Three Quarter", IF([Percent Met]3, 74.99 > 50, "Half", IF([Percent Met]3, 49.99 > 25, "Quarter", IF([Percent Met]3, 24.00 > 0, "Empty" )))))
Answers

Hi
Try this
= IF([% Complete]@row < 25, "Empty",
IF([% Complete]@row < 50, "Quarter",
IF([% Complete]@row < 75, "Half",
IF([% Complete]@row <100, "Three Quarter",
"Full"))))
It goes into a single row next to each other but have separated this so you can see the construction
This gives you the result. You can use any numbers or % I have used % Complete for ease.
Hope that helps
ATB
Purnima
Purnima Gore
Cierr Limited
Your Time is Important, you want to Stay on Track, We can help you use the Right Tools

That worked, thank you!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!