Put Numbering with condition

[SH_94]

Hi Community,

May i know how to write the formula in the multi-row formula tool  so that output is as per below:

The condition is that for the first month it will start with A whereby record ID is 1 for A , 2 for B , 3 for C and 4 for D. While for the second month onwards, it will opposite and start with D instead and so on.

Output

Many thanks

[ShankerV]

Hi @SH_94 

You can easily achieve with the help of Record ID tool.

Many thanks

Shanker V

[ShankerV]

Hi @SH_94 

Expected solution

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @SH_94 

Also achievable with the help of Multi Row formula

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[SH_94]

Hi @ShankerV ,

Thank you for the prompt response. I have just updated the question in the original post whereby the sequence for the input maybe different but the output is the one that i try to achieve

[ShankerV]

Hi @SH_94 

Yes, I see the question is amended now.

It is possible, few seconds please. 

Many thanks

Shanker V

[ShankerV]

Hi @SH_94 

Please find the expected solution

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[SH_94]

Hi @ShankerV , 

The output seem to be different with expected outcome. 

Basically It need to be follow by month first , then type follow by record ID. May i know how to derive the result expected as per the screenshot below ?

[ShankerV]

Hi @SH_94 

No, I see the same expected outcome as you requested.

Could you please share the outcome which you are seeing at your end.

Many thanks

Shanker V

[SH_94]

Hi @ShankerV ,

I just downloaded the file and run it .Below is the outcome of the worklfow .

Thank you