I have a list of SSL certificates and their expiration dates. I created a column that calculates the date 45 days before the expiration and then a view that only shows those items where the (expiration - 45) > Today.
I then set an alert for any changes to items in that view. However, I don't get an alert for items that pop into the view...I guess because the item itself did not change. Is there a way to send an alert based on date?
My SharePoint enviroment is locked down so I can't create custom workflows or connect via Designer.
View Complete Post