Hierarchical numbering patterns?

Anyone with experience setting up hierarchical numbering schemes?

I want to add a column that is hierarchically auto-numbered such that child rows are added to the numbering scheme as increased decimal points. For example 

1. Row 1

--1.1 sub item of row 1

---1.1.1 sub item of row 1.1

---1.1.2 sub item of row 1.1

---1.1.3 sub item of row 1.1

--1.2 sub item of row 1

2. Row 2

--2.1 sub item of row 2

---2.1.1 sub item of row 2.1

---2.1.2 sub item of row 2.1

---2.1.3 sub item of row 2.1

--2.2 sub item of row 2

The row number once generated would be static so that if I deleted a row, the other numbered rows continue to exist with their same numbering scheme unless I choose to have them renumbered. 

Further, I want to add a prefix to the number scheme based on a selection in a column. For example, if I have a column called "type", I can setup different prefixes of the number pattern based on the selected column value:


ID# Item Type

stry-1 first item Story

-accp-1.1 criteria one Acceptance Criteria

-accp-1.2 criteria two Acceptance Criteria

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!