Is there a more efficient way to transfer an autonumber column to another sheet?
I can go in-depth into our workflow, but to keep things simple, my organization is using VLOOKUP formulas to pull info from a repository sheet, send out a survey to a respondent, then update our sheet with any new info received from the respondent.
We occasionally have large influxes of data, so every column counts, since we often bump into the maximum cell count Smartsheet sheets can handle.
The way we've been matching rows to each other is by using an autonumber column to ensure they each have a distinct row ID. However, the autonumber row IDs don't transfer from one sheet to another, so we've had to make a helper column to ensure the row ID stays static when moved across sheets.
That's created another issue where the static row ID is often changed to a text field rather than a number, which breaks the VLOOKUP formulas. So, we've had to create a 2nd helper column that sets the 1st helper column to always be a number.
In theory, at least, this doesn't seem like it should require more than a single column. What would be ideal for us is a column that is autonumbered in our case creation sheet, then stays that number (and stays a number) when transferred across sheets, or when reported in a survey. Does anyone have any clever ideas for how to reduce the number of columns for this process (ideally to just one)?
Help Article Resources
Check out the Formula Handbook template!