Indexing with Multi Row Formula

Question

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!

RecordID test - r.xlsx

apathetichell · Accepted Answer

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.

KrishnaChithrathil · Accepted Answer

@bdoni001 Is this you want?

Input:

Output:

DenisZ · Accepted Answer

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

Please mark it as solved if it solves the issue.