Can we apply an automation using formula to maintain the graduation year record smart list data via Marketo?
Hi All,
We have some smart lists which utilizes "Residency Graduation Year" as a filter. In this filter we manually input the year as per the data requirements.
For say, we want a list of records who have completed the Residency Graduation last year (2022). Here is the snapshot of smart list for reference:

Likewise, we need to categorize for the records who have completed it in the previous years or who will be completing in the upcoming years. For this I have created smart list for every graduation record year date (Example for 1 year ago, for 2 years ago, 1 years from now, 2 years from now and so on...).
Question - I know that we cannot apply a formula in a smart list but can we create an automation leveraging Marketo which helps in updating all these smart lists automatically whenever the Calendar year changes ?