Traffic light

Wisaksana Djawi
edited 08/01/22 in Formulas and Functions

Hi, I'm trying to set-up a traffic light formula with the following data fields: %Complete, Start Date and End Date. The parameters are:

  1. If TODAY is 5 days from End Date AND %Complete is <100% then Yellow
  2. If End Date is < TODAY, then Red

Can anyone please let me know how the formula should be typed? I keep on getting "unparseable".

Thank you


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!