Provide Record ID per transactions chronologically

[hargquin]

Hi,

I am trying to assign a chronological ID based on transactions with the same text in certain columns and a differing date column. I have multiple transactions that are identical (in certain columns) except for the date. I am trying to assign a 'First' 'Second' or 'Third' etc. column based on transactions with a date assigned. I have tried to figure out a way by a formula or by a record ID and cannot seem to figure it out. Please help and thank you in advance.  

[clmc9601]

Hi @hargquin,

Have you tried any of the following?

- CReW's GroupByRecordID

- Tile's configuration of Unique Value in your non-date columns

- Multi-Row Formula with [Row-1:field]+1 grouped by your non-date columns 

I'm sure the community would be happy to mock up a workflow for you if you provide some sample data. 

I hope this helps! If it does, please consider marking it a solution so others may find it.

[apathetichell]

I think @clmc9601 suggestions are all great - I'd go for the tile tool personally. You may have to sort by date first.

[hargquin]

I've attached a sample below. When the three columns are identical but the date is different, that's when the workflow needs to create a 'First', 'Second','Third', etc. for the transactions.  

[atcodedog05 · Accepted solution]

Hi @hargquin 

Only posibble way for getting words it to have lookup table and add the wording.

Here is how you can do it.

Workflow:

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @hargquin 

I have updated the workflow. With the help of data in this link i have updated wording to be till Hundredth. 

Hope this helps : )