Trying to Input a formula to automatically generate a symbol

Paul Dieterich

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

Purnima Gore

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

Paul Dieterich

That worked, thank you!