RYG function based on Status and Start Date

I am able to have the Status (RYG) show up based on Status (which is tied to percent completed). I am trying to add the function so if the Start Date is in the future the status defaults to Green.

This is what I'm using for the RYG now:

=IF(Status@row = "In Progress", "Yellow", IF(Status@row = "Not Started", "Red", IF(Status@row = "Complete", "Green")))

I end up running into issues when I add "OR" and try to make status Green if Start Date is in the future.

Best Answer

  • David Tutwiler
    David Tutwiler Overachievers Alumni
    Answer ✓

    You could start with the Start Date at the beginning. So something like:

    =IF([Start Date]@row > TODAY(), "Green", IF(Status@row = "In Progress", "Yellow", IF(Status@row = "Not Started", "Red", IF(Status@row = "Complete", "Green"))))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!