Formula Help

Good morning Community,

Please could somebody help me figure this out. When the schedule date = today, the status is turning red, whereas it should be yellow. Any date past today should be red only. I hope that makes sense!

=IF([Scheduled Date]3 = "", "", IF([Date Completed]3 <> "", "Green", IF([Scheduled Date]3 <= TODAY(), "Red", IF([Scheduled Date]3 <= TODAY(10), "Yellow", IF([Scheduled Date]3 >= TODAY(10), "Blue")))))

Thank you.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!