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.

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.