So this is really simple. All you need to do is:
- Have a reminder date (not necessarily the due date). This can be a calculated field, based on due date (like =[Expiration Date]-30).
- Create a reminder view that filters based on the reminder date (is less than or equal to today).
- Use an alert or an RSS feed (now that was easy).
This thing does not need to be any particular kind of list or library. I know it's a brain dead simple solution, but if you were having a mental block, maybe this will help.
In creating the filter for the reminder view ("is less than or equal to todays date"), what is the formula I can write to represent "todays date" without entering the actual date? (b/c I don't want to have to update the date everyday!).
ReplyDeleteJust put in TODAY.
ReplyDeleteThanks - I had tried that but got a prompt saying that the "filter value is not in a supported date format". My reminder column was set up to expect a date - tried changing it to a single line of text, number, etc and those did not work either. What might I be doing wrong?
ReplyDeleteI know I have had issues getting some of these to work too. This last one worked fine the first time. Everything is a date and time field. I have an expiration date, and a reminder date (=[Expiration Date]-30).
ReplyDeleteYou might have to get out your SharePoint hammer (you use it on yourself and your computer).
to Anonymous: just put "[TODAY]"
ReplyDelete