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

Tags:

• ✭✭✭✭✭✭

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

https://www.cierr.com

• That worked, thank you!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!