Team -
I have a workflow that produces 5 columns (StepID, Action Cadence ID, Step Name, Parent Step Name, and Step.
The goal is to properly identify the steps. Step 1 is where [Step_Name] = RootNode, Step 2 is where [Parent_Step_Name] = RootNode, Step 3 is where the [Step_Name] associated w/step 2 appears in the [Parent_Step_Name]. I'm trying to create a dynamic formula that can properly label the step columns with a 1, 2, 3, 4, etc. Would appreciate any input anyone can offer. Thanks - Ryan