I am trying to add traffic lights to my Smartsheet but I cannot get the formula to parse

edited 07/27/22 in Formulas and Functions

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

Any ideas?

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!