Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Auto-Increment Change Orders
I have a column [Entry Type] which contains (Task, Change, Other). I use a web form to allow others to enter change orders. I would like to automate naming these change orders as Change Order 1, Change Order 2, Change Order 3, etc.
I can use =COUNTIF([Entry Type]:[Entry Type],"Change") to obtain the number of change orders entered. How can I automate a column entry to auto-increment only change orders?
Adding or subtracting one doesn't suffice as it changes all entries. I believe it needs to take into account the created date or an auto-number column that could be referenced.
Thanks in advance,
Charles
Comments
-
Hi,
This should give you an idea.
Formula Column:
=COUNTIF($[Entry Type]$1:[Entry Type]1, "Change")
Entry Number Column:
=JOIN([Entry Type]1:Formula1)
-
Good solution Mehmet
Craig
-
Thanks Craig!
Mehmet
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives