IF Statement and RYG text values
Im running a routine to identify when a record changed for assets and flag it based as follow
If the Values on Current Status and New Status are the same then GREEn
If the Values arent the same RED
if Current Status has any value and New Status is equal #NO MATCH then I wanted to be Yellow but it is not working no matter how I try. the only working formula I have is the one below that if the value is equal then is GREEN otherwise red .
=IF([Current Status]@row = [New Status]@row, "Green", "Red")
Any help will be appreciated
Help Article Resources
Check out the Formula Handbook template!