Hello Community,
I am trying to build a workflow that will update a custom numeric field named “Sequence”. This field will run on the Project object and then assign a numeric value to every Milestone regardless of how many.For example:
Milestone1 = 1001
Milestone2 = 2001
Milestone3 = 3001
etc.
The issue I am having is the variable I am configuring within the rule only provides me the last Milestone value and then assigns it to all the Milestones. Per my example above, there are 3 Milestones and the last Sequence value is 3001. All 3 Milestones are given this value creating an undesired duplication when ran on Sub Items from Project object.
Question: Is there a way to make this run so that the values are specified correctly per my example above without the duplication?