I am trying to add traffic lights to my Smartsheet but I cannot get the formula to parse
I am trying to add Green, Yellow, Red stop lights to my Smartsheet. I am trying to add the following formula and keep getting a parsing error:
=IF([Intel Forecast Acceptance Date]17 < “10/15/2022”, “Yellow”, IF(AND([HPE Financial Qtr]17 = “Q3/2022”,[Intel Forecast Acceptance Date]17 > “07/31/22” then "Red", Green")))
17 is the row number
Intel Forecast Acceptance Date is a date
HPE Financial Qtr - Text/Number
Help Article Resources
Check out the Formula Handbook template!