If Today is Greater Than

Just Jean

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.

 

Paul Newcome

You can go to the Alerts & Actions menu and set up a notification. The process would be almost identical to what you have there once you get into the notification edit menu.