Help with a complicated formula


I need all of this written as one formula. I've been trying, but can't make it work. Can you help me?

If today’s date > 9/30/20 and % Complete is < 75% At Risk (Red);  

if today's date is > 10/30/20 and % Complete < 85% At Risk (Red); 

if today's date is > 11/30/20 and % Complete < 95% At Risk (Red)

("Red" = Heatmap Rating)

Best Answer


  • Mary Shevlin
    Mary Shevlin ✭✭✭✭

    Thank you!!! That worked. I am adding this to my list of formulas that work.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!