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
Answers

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

=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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 429 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!