# Formula and Symbols

I am trying to create a formula on the symbols that if the %Scrap is below the Scrap Target it will be Green otherwise Red

• Overachievers

HI @ghie

This formula should deliver what you need

`=IF([%Scrap]@row < [Scrap Target]@row, "Green", "Red")`

Hope that helps

Thanks

Paul McGuinness

• Hi @Paul McGuinness, that's what I initially tried, but it always gives me a return value of Green even if it doesn't meet the criteria

• ✭✭✭✭✭✭

Hi @ghie

The formula @Paul McGuinness suggested is correct.

Perhaps your "Scrap Target" cell value is a text, not a number. The image below shows if the "Scrap Target" is a text, the formula " [%Scrap]@row < [Scrap Target]@row" returns true instead of giving you an error. It may be that if you divide a number by zero, it becomes an error, but the result is an infinite value, so " [%Scrap]@row < [Scrap Target]@row" may become true.

• How would I convert the Scrap Target to number, right now the value of the scrap target is under a formula.

Formula of the Scrap Target is under:

=IF(Machine@row = "1", "9.5%", IF(Machine@row = "2", "3.7%", IF(Machine@row = "3", "6.5%")))

• ✭✭✭✭✭✭
edited 08/05/24

=IF(Machine@row = "1", 0.095, IF(Machine@row = "2", 0.037, IF(Machine@row = "3", 0.065)))

Please set the display setting of "Scrap Target" to "%".

• @jmyzk_cloudsmart_jp, it finally worked! Thank you both, @Paul McGuinness @jmyzk_cloudsmart_jp

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!