Conditionnal auto numbering
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 !
Answers
-
Insert your system generated auot-number column, then use a text/number column that says
=IF([Column A]@row = "Yes", [Auto-Number]@row)
-
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.
-
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 !
-
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))
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!