Help

Show Upcoming Step based on chronological order

Topic Labels: Formulas
514 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Rachael_Castela
6 - Interface Innovator
6 - Interface Innovator

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!

image

image

image

image

0 Replies 0