Formula and Symbols

ghie

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

Paul McGuinness

HI @ghie

This formula should deliver what you need

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

Hope that helps

Thanks

Paul McGuinness

ghie

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

jmyzk_cloudsmart_jp

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.

https://app.smartsheet.com/b/publish?EQBCT=aff152d4959b4e6b83c219256af961df

ghie

@jmyzk_cloudsmart_jp ,

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

jmyzk_cloudsmart_jp

@ghie

=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 "%".

ghie

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