
I have created an employee training and certificates sharepoint list. I wanted to set reminders when a certificate like first aid was about to expire. But with many employees and many certificates, not all amployees need to have certain training certificates.
Therefore there are many times when the date expiry is blank that corrosponds to an employee name that doesnt need that cert.
see below image. Every employee has a license so setting conditions for dates to go red when expired is easy. Next cert column is an implenet training that not everyone does or needs. If i set condition about an expiry the blank spaces all go red. I need a tutorial on how to set email or text reminders when someones certificate is expiring. i thought it wouldnt be hard but...
If it doesn't error out other processes you have, could you input a date that everyone knows it means they don't have one...something like 12/31/2199?