How to give record id based on multi line condition

[dizy_11]

Hi all,

I'm stuck with giving record id in sequence based on page column. The input is like this:

The output which i want is:

Can anyone please help me with this?

Thanks in advance.

[Jonny · Accepted solution]

HI @dizy_11 ,

I created this workflow for you, using the multirow formula tool.

let me know if this is what you are looking for?

cheers!

Jonny

[Emil_Kos · Accepted solution]

Hi @dizy_11,

So it looks like we need to add 1 to the previous value if the page will change.

Multi-row formula will work perfectly for you. 

Output:

[dizy_11]

Thanks alot 🙂