If Today is Greater Than

Just Jean
Just Jean ✭✭
edited 12/09/19 in Formulas and Functions

Hello,

I have these columns on a sheet:

Expected Return Date (date)

Actual Return Date (date)

Media Manager (contact)

How do I send an email to the Media Manager if the Expected Return Date has passed? 

"If today is greater than Expected Return Date and Actual Return Date is blank, send notification to Media Manager"

Thanks.

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!