Formulas

Michael Hair

I am trying to easily auto populate a column based off a Job ID I type in. For example, if I were to type in a Job ID, could I have that same ID auto populate the next 5 rows of that Column. If I were then type in a different Job ID on the 7th row, could I have that new Job ID auto populate the next 5 rows and so on. Is this possible and if so what formula can I use?

jmyzk

Simple =[Row ID]2 formula method

Using Parent Chidren relation if you can use Identation (More logical?)