# Conditionnal auto numbering

Options
✭✭✭✭

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.

• ✭✭✭✭✭✭
Options

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

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

• ✭✭✭✭✭✭
Options

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭
Options

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 !

• ✭✭✭✭✭✭
Options

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))

• ✭✭✭✭
Options

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 !

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!