Can you create a column formula for auto-number generation that will recognize ancestor relationship
I have a sheet that I would like to custom create an auto-number formula so a record ID is given when a new record is submitted, but I also also want it to be able to recognize descendant rows and give them the same Record ID as the ancestor row (instead of generating a new record ID for every new row). Below is an example of the result I'm aiming for.
Help Article Resources
Check out the Formula Handbook template!