Conditionnal auto numbering

emmanuel edon

Hi there, i'm looking the possibility to generate or not a number depending of the value on another column.

For ex, column A : Yes/NO

Colum B autonumbering

If A = Yes, i will have a auto number, if no, the field stays blanck.

Many thanks in advance !

Paul Newcome

Insert your system generated auot-number column, then use a text/number column that says

=IF([Column A]@row = "Yes", [Auto-Number]@row)

Andrée Starå

Hi @emmanuel edon

I hope you're well and safe!

Do you need to have the numbers like 1,2,3, or does it not matter?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

emmanuel edon

Hi Paul & Andrée, thanks Paul, it works fine, many thanks, but yes Andrée, i wanted to have an ordering number , is there any solution for that? Thanks again !

Paul Newcome

TO have it going in order without skipping numbers, you should be able to use this...

Insert a text/number column (we will call "Row" for this example) with the following column formula:

=MATCH([Auto-Number]@row, [Auto-Number]:[Auto-Number], 0)

Then in the text number column that outputs the number, change the formula to this...

=IF([Column A]@row = "Yes", COUNTIFS([Column A]:[Column A], @cell = "Yes", Row:Row, @cell <= Row@row))

emmanuel edon

Hi Paul, many thanks for your answer, but , i do not catch it. Please find a screenshot of what i'm looking for.

The auto numbering in the column "Num Cde SST" is displayed by the column type with auto numbering defined in the properties.

But, i would like to have this number only displayed if the column Nom SST is not empty.

So i created a second column called "Numero CDE SST". In this column, i'm trying to have an ordering number like BDCSST00121-07-08. So i tried your formula but i think i miss something.

Many thanks again for your help !