Formatting Warehouse locations

[Steve337]

trying to use the smart complete to create a range of warehouse locations. here is a sample below. with a max of the last decimal of 3. Thanks!

[TABLE="width: 173"]
<tbody>[TR]
[TD]011.001.001[/TD]
[/TR]
[TR]
[TD]011.001.002[/TD]
[/TR]
[TR]
[TD]011.001.003[/TD]
[/TR]
[TR]
[TD]011.002.001[/TD]
[/TR]
[TR]
[TD]011.002.002[/TD]
[/TR]
[TR]
[TD]011.002.003[/TD]
[/TR]
[TR]
[TD]011.003.001[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Welcome to the Board!
What cell is the very first entry being placed in?
I want to use some calculations dependent upon row number, so if I know the starting row number, then I can write the formula to work exactly for you without you having to make any changes to it.

 

[Joe4]

If the first row you are putting this formula in is row 1, then this put this formula in and copy down for all other rows:

="011." & TEXT(INT((ROW()-1)/3)+1,"000.")&TEXT(MOD(ROW()-1,3)+1,"000")

Any other row will require some adjustments.

 

[Steve337]

the location is all in one cell. attached is a screen shot of the form i was sent to fill out.
https://ibb.co/jeUzby

 

[Joe4]

the location is all in one cell. attached is a screen shot of the form i was sent to fill out.
https://ibb.co/jeUzby

I am unable to view that file from my current location (blocked by my security department).
Did my solution not work for you?
If not, please answer the question I asked in my first reply.