Assign unique ID for duplicate submissions
I am trying to add a column that will show a unique identifier for all form submissions that have a duplicate value in the primary column. I would like to track both the individual submissions (which I did with the auto generated column) and would also like to track each unique organizations being submitted.
I was able to create a helper or duplicate column, but cannot seem to figure out how to keep sequential order for duplicate submissions.
I have been using variations of this formula: =IF(COUNTIF([Organization Name]$1:[Organization Name]1, [Organization Name]1) = 1, MAX([Organization ID]$1:[Organization ID]1 + 1), VLOOKUP([Organization Name]1, [Organization Name]$1:[Organization ID]1, 2, 0))