Logic Needed for Turning on the Gray Stoplight
06/01/18 edited 12/09/19 in Smartsheet Basics ... I am trying to add logic in the following string that will turn on the "Gray" stop light ball if the % Complete cell is left blank. ... =IF([% Complete]18 < 0.5, "Red", IF(AND([% Complete]18 >= 0.5, [% Complete]18 < 1), "Yellow", IF([% Complete]19= 1, "Green", IF([% Complete]19= blank, "Gray")))