How do I send a notification of training expiring to other contacts?


I have a sheet set up tracking the completion and expiration date of training for personnel. Each row has the contact info for the person it relates to. How do I send a notification to that person when their training is within 30 days of expiration?

I've tried several workflows, and it keeps sending a notification with ALL rows that have expiring dates, and includes all the columns, instead of the column that met the criteria of "expiration date within the next 30 days."



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!