Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community

Sequence no. creation automation using formula

Copper Contributor

Hi guy,
Need some help with sequence creation.
We have a task list with 4 levels of Tasks
I want to generate a sequence such that 

Level

Sequence Start

Lvl 1

1
Lvl 21.1
Lvl 31.1.1
Lvl 41.1.1.1

 

I've attached a sample file, but I would like to know if anyone has done something like this before.
the sequence should also stop when the level changes... ie .

Task level

Sequence Start

Lvl 1

1
Lvl 21.1
Lvl 31.1.1
Lvl 41.1.1.1
Lvl 4

1.1.1.2

Lvl 41.1.1.3
Lvl 21.2
Lvl 3

1.2.1

Lvl 41.2.1.1
4 Replies

@Pratichi 

In C7:

="Lvl "&LEN(D7)-LEN(SUBSTITUTE(D7,".",""))+1

Fill down.

I actually want it the other way... ie i know the level, I need a formula to give me the sequence. :(

@Pratichi 

But your workbook already has the 1.1 etc. but not the levels...

What you're looking to do is possible with clever use of SEQUENCE. I'm not trying to dissuade you from using Excel, but you may want to consider MS Word for this task. Word can produce the multi-level list you're looking to use without much legwork.