Expiration dates - how to monitor, notify, and track


I am a Safety Manager for a Crane Rental company.


We have a large fleet of semi tractors, pickups, service trucks, mobile crane, etc.

Each of these have annual certifications, vehicle registrations, insurance card dates, vehicle service dates for various mileage related tasks (oil changes, etc.).

I have a master equipment smartsheet, and would like to use the date cell to indicate when specific items are due.

Question: How can I set alerts / notifications to our Operations management and service teams in advance of an item expiring.

for example, is a certification for a crane is due on November 10th, 2021, I would like the sheet to send out a notification or alert to the Operations team to schedule the inspection. I want reminders at 30 days, 10 days, and 2 days.

Any assistance with this type of functionality is appreciated.


~Rich Neel