IF statement - Less than 3 weeks from today


I am looking for help on a formula for IF([Proposed Effective Date]@row is less than 3 weeks from today display "Rejected" AND IF([Have you received quotes form competitors?] = Yes then display "Rejected"

So if one condition applies it displays "Rejected" or if both then "Rejected" displays as well.

Thank you so much!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!