Flag Red if under 100% or Past Due




Here is what I am trying to accomplish!


In the column with the flags (highlighted yellow), I would like the flag to turn red when the Percent Complete Column (highlighted Green) is less than 100% OR if the Completion Date Column (Highlighted Blue) has a date past today's date. 


Please let me know if you can help with this!



smartsheet discussion image.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!