WBS with additional naming


Hello! I'm using the Work Breakdown Structure - Column Formula Configuration template (https://community.smartsheet.com/discussion/77827/work-breakdown-structure-wbs-column-formula-configuration/p1).

I am wondering if it can further be customized so the WBS. The current configuration is 1 1.1, 1.2, 2, 2.1, etc.

I'd like to create a configuration where the department name is included and the count only increases based number of "projects" for the department. For an example:

DepartmentA 1

DepartmentA 1.1

DepartmentB 1

DepartmentB 1.1

DepartmentA 2

DepartmentA 2.1

DepartmentA 2.2

DepartmentA 2.3

DepartmentB 2

DepartmentB 2.1

I think there would need to be some sort of countifs formula but I haven't figured out how to incorporate it with the prefix and suffix formulas.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!