Forum Discussion
Solved
Automatic Carton Numbering
Hello and thank you, So here's the deal. I have a spreadsheet with the entire selection of possible products ordered from us by a customer. I would like to be able to receive a PO from the cust...
rshenk3
Like this?If that's the case, then we change the initial value in SCAN from 1 to 0:
=LET( carton_numbering, LAMBDA(a, v, IF( v = "", TEXTAFTER(a, ",", -1, , , a), TEXTJOIN(",", , SEQUENCE(v, , a + 1)) ) ), SCAN(0, boxes, carton_numbering) )
Yes, I need the "Box #'s" to start at 1.
rshenk3
Like this?
If that's the case, then we change the initial value in SCAN from 1 to 0:
=LET(
carton_numbering, LAMBDA(a, v,
IF(
v = "",
TEXTAFTER(a, ",", -1, , , a),
TEXTJOIN(",", , SEQUENCE(v, , a + 1))
)
),
SCAN(0, boxes, carton_numbering)
)
- Yes, that's it! Thank you so much for your help! Your solution is much more efficient and I will take what I learned here to future projects. thanks again!
- Glad to help. Good luck with the business!