Generate Sequence

Question
1

HI,
For Each Project , I had like to have 23 tasks starting from 01-23, in example below

  • 3376 needs to generate from 13-23
  • 3377 needs to generate from 19-23

All my efforts to use sequence have failed.

Project TaskID# Project TaskSequence# TaskPipeline
3376 01 3376-01 Completed
3376 02 3376-02 Completed
3376 03 3376-03 Completed
3376 04 3376-04 Completed
3376 05 3376-05 Completed
3376 06 3376-06 Completed
3376 07 3376-07 Dropped
3376 08 3376-08 Dropped
3376 09 3376-09 Dropped
3376 10 3376-10 Dropped
3376 11 3376-11 Dropped
3376 12 3376-12 Completed
3377 01 3377-01 Completed
3377 02 3377-02 Completed
3377 03 3377-03 Completed
3377 04 3377-04 Completed
3377 05 3377-05 Completed
3377 06 3377-06 Completed
3377 07 3377-07 Completed
3377 08 3377-08 Dropped
3377 09 3377-09 Dropped
3377 10 3377-10 Completed
3377 11 3377-11 Dropped
3377 12 3377-12 Dropped
3377 13 3377-13 Not Started
3377 14 3377-14 Not Started
3377 15 3377-15 Not Started
3377 16 3377-16 Not Started
3377 17 3377-17 Not Started
3377 18 3377-18 Not Started

PS - By deduping projects , copying tasks list , I am able to get it done but clunky

clunky trial with cross.transform (6.3 KB)

2

I had a look, but can’t see a simpler way to do it.

1 Like
3

The only use for Sequence would be to replace input:

01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
18
19
20
21
22
23

With input:

01
23

And then use Sequence to fill in the missing numbers. But you would also have to use Pad to add the leading 0. So you wouldn’t gain much.

4

This also looks to me like a clean (not clunky) solution that fulfils all requirements