Forum Discussion
Sequence no. creation automation using formula
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 2 1.1 Lvl 3 ...
- I actually want it the other way... ie i know the level, I need a formula to give me the sequence. 😞
- 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.
But your workbook already has the 1.1 etc. but not the levels...
