Hello Everyone,
I'm looking for some advice on automating Project ID generation in our CopyRow Automation process. My department uses this tool for project intake when sending work between teams. However, we need to include a unique Project ID that transfers to the destination sheets.
Currently, our project managers spend a lot of time manually linking cells. They want to start using DataMesh, but we're hitting a roadblock: we can't use the AutoNumber column for this because the destination sheet can't have a pre-existing column name when using CopyRow.
I'm considering creating a Project ID using a formula in the Text/Number column, possibly with a combination of Prefix and Suffix helper columns. The problem is, I'm stuck on how to generate the unique number itself.
Has anyone dealt with this or have suggestions on how to approach it?
Thanks in advance for your help!