Show Upcoming Step based on chronological order

[Rachael_Castela]

Hey there,

I need to show the most current step in progress in my “Is Current Step?” formula as “1”. I’m running into an issue with my current formula because some of the Upcoming Due Date Lookup dates are the same. (Example below for the Content Quality Objective, where it looks like there are two current steps).

Ideally the formula would say “Is Current Step?” = 1 when Actual Completion Date (per Objective) is empty. It’ll then look at the next upcoming date based on the Revised Completion Date. If those dates are the same, it’ll look at the Step # and it should be the next one, chronologically.

FYI I need it to be “1” because my Objectives tab will show the current step based on the condition (below).

Thank you in advance!

Show Current Step, based on complete, date Formulas

Hey team! 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! [image] [image]