I have a column which has say the following data:
I want an ID column next to it that will have the following numbers:
The ID is based on the sequence for only the item. When A appears first, its ID is 1, and in the next appearance it’s ID is 2 and so on.
Any help is well appreciated. Thanks.
Do you have an already existing set of data for this, or you want an idea to start building it?
If you have not started, I would advise using a custom form, fill the item input into a user-specific column, make a relation from that usc to the existing item column, count the number of items using a rollup, then use a math column to add 1 to that count, use it as the ID for the next item.
If you have already had the list of items, I would advise using a Google Sheet formula for this.
Please continue to post your questions under the #help-how-to category, this will help us keep the community well organized. We appreciate your help !