Deals are associated with a Year. Specifically Deal Document Set has a Site column called UW Year, which represents the year for this deal. We want to choose the year from a dropdown – I’m open to how to implement the values. Can be a list, term set, hardcoded list, whatever will work.
This is the tricky bit: Now in 2020, we want to see 2020, 2021 and 2022. Works great for this year. Deals will be associated with one of those.
But next year, we want the choices to be 2021, 2022 and 2023. However, Deals that have 2020 should still retain 2020.
It's like you want a dropdown for convenience only, but not to be linked with the values in the dropdown. If they are removed tomorrow, you lose nothing except convenience. If you edit an item, the Year value will remain the year it was set to regardless of which years are currently in the dropdown.
Any ideas how to solve this? Ideally without coding.