IF statement - Less than 3 weeks from today

Options

Hello,

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!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!