I have a sharepoint list with current and upcoming cases, and a list of years in which these cases will be completed. I would like to create a page with web parts showing cases for each year currently in the years list (there will always be four).
I can manually adjust the criteria to match the year, in the view settings, but I would like this to update automatically when the list of years is updated. Is this possible, and how would I go about doing this?
E.g. 2018, 2019, 2020, 2021 in the years list may give:
2018 2019 2020 2021 Case1 Case2 Case3 Case4 Case7 Case6 Case9 Case8