IF formula and dates: 'Red' status if the % complete is not 100% and the date is in the past

Hi there,

Is it possible to incorporate dates in an IF formula? Essentially I want the RAG status to automatically go to 'Red' if the %complete is not 100% and the date is in the past - how would I go about doing this?

Thank you

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!