I have a SharePoint View on a list that calculates when the list item was last updated using [Today]-1 based on the default field "Modified". The filter is typed out below also. The view works perfectly but I am unable to send an email alert if anything pops up in this view. I believe that in order for an email alert to work, a list item has to be modified. In this filter, nothing is being modified, it is just a list item that is aging and eventually meets the criteria to show up in this view if it is not touched within 24 hours.
Is there any way to send an email to a person when items show up in this view?
Show the items when column "Modified" is less than [Today]-1
When Column "Status" is not equal to "Resolved"
When Column "Status" is not equal to "Closed"