Indexing with Multi Row Formula

[bdoni001]

Hello everyone.

Need a help here.

I want to create an indexing list as follows:

The goal is that everytime the value in the reference column changes, the RecordID restarts back to 1.

Anyone can give some suggestions on how to achieve this?

Thank you!

[apathetichell · Accepted solution]

tile tool.

Unique value

reference

tile sequence number is your recordid - no multi-row formula needed

but for fun - what you'd do is group by reference and set values that don't exist as equal to null() in the multi-row formula options

if [Row-1:Reference]=null() then 1 else [Row-1:Reference]+1 endif

if you won't want to set values that don't exist to equal null() you can do if [Row-1:Reference]!=[Reference] then 1 else [Row-1:Reference] endif

the key is seeing where the values change either before the row before doesn't exsit or the value of refrence-1 isn't equal to reference.

[bdoni001]

"tile sequence number is your recordid"

Does this mean I need to tick 'RecordID' in the Group by Columns?

[apathetichell]

No. The column you have above called RecordID is the RESULT of your Tile tool Tile calls it TileSequenceNumber. Reference is your group by column.

[KrishnaChithrathil · Accepted solution]

@bdoni001 Is this you want?

Input:

Output:

[DenisZ · Accepted solution]

Please see attached workflow which solves it with the asked multi row formula

Please mark it as solved if it solves the issue.