Moving rows from one sheet to another where both have different auto numbering conventions?

J. Morrish

Hello,

My organization is using Smartsheet to keep track of contract requests as they are submitted and reviewed. I use a sheet which auto numbers each row with a contract request number (prefix CRF-###). Once the request is approved, I want to have an automated workflow move the row to our active contract tracker and assign a number with a different prefix (CON-###). Is there any way I can achieve this? Right now, the CRF-### number overrides the settings in the active contract tracker, so it doesn't assign the CON-### number but just copies over the CRF-###.

Darren Mullen

@J. Morrish If you are ok with keeping the original number, you could create a new column and use the SUBSTITUTE() or REPLACE() functions to swap out the prefix. Your sheet would then have both references.

Darren Mullen

@J. Morrish If you are ok with keeping the original number, you could create a new column and use the SUBSTITUTE() or REPLACE() functions to swap out the prefix. Your sheet would then have both references.

J. Morrish

@Darren Mullen I think that could work! I practiced a bit with using SUBSTITUTE() and it seems to be working as expected. Thank you!

Darren Mullen

@J. Morrish Great! Thanks for following up!