Using Auto number with child (indented) rows
Hello,
Is there a way to set up a column with autonumber fields with a format something like: #.#, where the # after the decimal indicates the subtask. For example:
1.0 Task A
2.0 Task B
2.1 Task B1
2.2 Task B2
2.3 Task B3
3.0 Task C
The decimal could be dash or some other character. I'm open to other setups / hierarchical numbering schemes. I'm trying to find a way to prevent task B1 from being auto numbered "3".
Thanks.
-Dave
Answers
-
Hi @David Fennell
Hope you are fine, you can do that by creating another sheet contain all the characters you will use ( A,B,C ....Z) with a counter for how many time you use this character in your original sheet then design a formula to use this counter to format the number of your new row. for example
if you use B character 6 times randomly in your original sheet then the counter will register 6 and the number for your new task will be ( 2.5 Task B5 )
i did it before and it takes time to design it, so if you interested please call me in my Email : bassam.k@mobilproject.it or send a whatsapp to my mobile ( +966 530973300 ) and we can discuss this job.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives