simple Excel fumula does not work

Reto Fröhlich

hi

Has andbody an idea to trasform this simple excel formula into smart sheet? 

 

=IF(A1=0;"Red";IF(A1=100;"Green";"Yellow"))

 

thanks for your help

Travis

Try this:

 

=IF(A1 = 0, "Red", IF(A1 = 100, "Green", "Yellow"))

 

Just make sure you change A1 for the correct cell reference. 

 

Here is information from our Help Center on formulas in Smartsheet: http://help.smartsheet.com/customer/portal/articles/775363-using-formulas

 

One more note: If you are referencing a % Complete cell, change 100 to 1. (1 = 100%. 100 = 10000%)