Put Numbering with condition

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

Record ID.xlsx

Common Use Cases

Accepted answers

All comments

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

Put Numbering with condition.yxmd

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

Multi row Put Numbering with condition.yxmd

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

Record ID.xlsx

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

Latest amended Put Numbering with condition.yxmd

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 ?