Split Dates


I am trying to get if split dates is in the last 7 days go orange and if split dates is 8 days in the past go red but it wont work it focus on the over the past 7 days only

I enclose a image of my conditional formatting.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!