Multi Row Formula help!

[JamesBarzda]

Hi all,

I'm struggling to configure a multi-row formula tool to do the following

Requirements - whenever the word 'Box' is found in 'transactions by VAT box' column, I need the value to appear in the 'Box Number' column. E.g. for the rows in the screenshot, 'Box Number' would read 'Box 1' and then, when Box 2 appears in the 'Transactions by VAT Box' column, if would update and read box 2, and so on for box 3, box 4, box 5, box 6, box 7, box 8 and box 9.

The 'Box Number' value would continue until the next box contains is found e.g. 'Box Number' would contain 'Box 1' until 'Box 2' is found in the 'Transactions by VAT Box' column

Thanks in advance!

[ShankerV]

Hi @JamesBarzda 

I believe you are expecting the below output.

Many thanks

Shanker V

[Christina_H · Accepted solution]

Try this formula:

if left([Transactions by VAT box],3)="Box" then [Transactions by VAT box] else [Row-1:Box number] endif

[ShankerV]

@JamesBarzda 

As a testing, have tried with huge dataset also.

Working as expected if I have in different formats too.

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V