Formula Help, please


Good afternoon, everyone:

I'm trying to write a formula that will do the following:

If the end date is 14 days or less from today give me a yellow stoplight if the end date is past due give me a red stoplight, if the end date is greater than 14 days from today give me a green light and if the % complete=100% regardless of the dates give me a green stoplight regardless and if the end date is blank give me a blue stoplight.

I've been trying but have had no luck. Appreciate any assistance. Thank you so much.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!