i have two lists, list A creates events, list B creates reports based on events on list A.
I currently have a lookup field (in list B) that pulls the event name from List A, that way they can select the event they are reporting to. However, Since they are going to be doing hundreds of events in a 2017, they want to be able to filter the drop down list in list B to exclude those events that are 30 days and older from the event start date.
List A has Event Name, Event Start Date columns.
I feel like this is the answer (see link below), but i can't reference to a different list when using calculated columns.
Any ideas? Thanks!
BTW I'm using Sharepoint 2013 (Online)