Partial cell population

Ed Gadd

I have a Part Number column The part number is combination of letters and numbers. The majority of the number is the same each time with only the last three digits changing. The column does not run in numerical order as the part number may appear more then once.

Is there a way for the cell to populate the complete part number when just the last three digits are input?

Thanks in advance

Toufong Vang

If you have a column called "Prefix" where you have the letters and numbers that--for the majority of the time, remain the same--you can have another column, "Number", where you enter the last three digits.

You would use a column formula in your "Part Number" column/field to create the full part number.

= [Prefix]@row + [Number]@row

Ed Gadd

Thanks for the response. It's unfortunately not quite what I'm looking for.

I'm looking for convenience to that by inputting the last 3 digits the whole part number will appear. I know this can be achieved on similar spread sheet software

Paul Newcome

Are you able to provide some screenshots for context?

Ed Gadd

Hi @Paul Newcome,

I've copied a picture into this comment. You'll see the P/N but I wish to only type the last 3 digits, the rest will always be populated when the last 3 digits are input. I know this is possible on other platforms. But is this availiable on Smartsheet's?

Thank you

Paul Newcome

You would need at least one other column with a formula that will output the prefix and then pull in the number from the column you type the number into. You won't be able to have it populate the same cell that you are typing the number into.

="RES" + RIGHT("00000" + [Manual Number Column]@row, 5)