Is it possible to generate a part number from row data?

Chris989

Can this be done; we currently manually generate part numbers and I'm wondering if it can be done using a formula or another option in Smartsheet. example below.

https://publish.smartsheet.com/4336d59fcd784801878bf41fada8ec1a

Part number would end up being, SDE-04111YI2E82Y from the inserted URL

Any help would be great.

Chris989

Hello Again Paul,

I figured out how to get around the AI generation. Below is more of what you asked for the #unparisable.

Paul Newcome

You don't need to use AI. You can type formula directly into cells.

Based on your last screenshot though, it looks as if your column names re not being recognized. Instead of typing out the column names, click on the cell that is in the column you are referencing on the row you want it to reference.

kowal

Hi @Chris989,

I am just wondering how the SDE-XXXX is connected with the link from your order.

There are different formulas for text that can be used to extract from any text part of it (if some conditions are met)

Unless you want to use some kind of dictionary where in one column you will have SDE-XXX and in other the address so you can use VLOOKUP to generate 3rd outcome.

Chris989

Hello Kowal,

The SDE-xxx would be in the SDE P/N collum. The columns to the right of that have some verbiage in it and then an = x, either a number or a letter. The = x in all the columns is what dictates the SDE P/N.

Let me know if you need anything more. I'm not very good with complex formulas.

Paul Newcome

It looks like you would just add a bunch of RIGHT functions together into a string.

="SDE-" + RIGHT([Safety Option]@row) + RIGHT(Voltage@row) + RIGHT([Drive 1]@row) + ……………………

Chris989

Paul,

Ill give it a go and see how it works.

Thanks,

Chris989

Hello Paul,

I have is written out as so, ="SDE-" + RIGHT([Safety Option]@row) + RIGHT([Voltage]@row) + RIGHT([Drive 1]@row) + RIGHT([Drive 2]@row) + RIGHT([Cable]@row) + RIGHT([Disconnect]@row) + RIGHT([Power Supply]@row) + RIGHT([UltraPRO]@row) + RIGHT([Fieldbus]@row) + RIGHT([Feedback]@row) + RIGHT([Safe Torque Off]@row) + RIGHT([Breaking Resistor]@row)

For some reason it won't generate the formula. I have tried a couple other ways and is either unparsiable or a circular reference. Any ideas?

Best Regards

Paul Newcome

The formula above… Which error is it outputting? It cannot go into a cell that is being referenced by the formula, and I don't see anything right off that would throw the unparseable error. Can you provide a screenshot of the formula open in the sheet as if you are about to edit it?

Chris989

Hello Paul,

I can't even get it to generate the formula. Is the AI the only option to use currently?

Chris989

Hello Again Paul,

I figured out how to get around the AI generation. Below is more of what you asked for the #unparisable.

Paul Newcome

You don't need to use AI. You can type formula directly into cells.

Based on your last screenshot though, it looks as if your column names re not being recognized. Instead of typing out the column names, click on the cell that is in the column you are referencing on the row you want it to reference.

Chris989

Paul,

It took a little work around to get the cells to be recognized but, it finally works. Thanks for all the help.

Best Regards,

Paul Newcome

Happy to help. 👍️