Within an Epic, we have 18 custom date picker fields to represent the launch date for each of our 18 markets. I want to have another custom field called, "Next Launch Date", where it looks at the 18 different market launch dates and returns the next chronological date from amongst the 18. On any given launch, some or all of the 18 markets will have a launch date. For those markets that will not launch, the field is empty. But there is at least ONE market launch date. As an example:
If today is November 17, 2019 and I expect to launch in Market 1 on December 15, Market 2 on December 20, Market 3 on November 19 and Market 4 on November 29, then when I look at the proposed "Next launch Date", the date shown would be November 19 because (as of November 17) the next Launch date is Market 3 on November 19. When I look again on November 20, the date shown would be November 29.
I've looked at calculated fields but cannot figure out how to proceed. Any guidance?
