I want to be able to show my “Current Step in Progress”, based on the information in my “Steps” table.
How it should look:
If there is an actual completion date, the formula should look at the next upcoming step, based on the date found in the projected completion date.
In this case, the “Current Step in Progress” for the Merchandising Acceleration Program should be S2, since S1 has an actual completion date.
Thanks in advance!