Is there a way to show an exact percent in Smartsheet?
Hello,
Looking to show a completion chart that corresponds to % Complete in my chart. What would be the formula to show 0, 25, 50, 75 and 100% complete that corresponds to the Completion graph that shows the similar amount completed? (Far right column needs to correspond to the farright column). Thanks!
Answers

you'd have to do a nested IF statement.
Maybe there's an easier way but this is how my brain works!
Use this in your "Completion" column where you want the symbol.
=IF([% Complete]@row = 0, "Empty", IF([% Complete]@row <= 25, "Quarter", IF([% Complete]@row <= 50, "Half", IF([% Complete]@row <= 75, "Three Quarter", "Full"))))
here's a link to they syntax for the symbols:
Available symbols for the symbols column  Smartsheet Learning Center
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!