WBS with additional naming

BrendonP12222

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.

jmyzk_cloudsmart_jp

Hi @BrendonP12222

I would change the Suffix formula as follows;

=MATCH(UniqueID@row, COLLECT(UniqueID:UniqueID, [Parent ID]:[Parent ID], [Parent ID]@row, Department:Department, Department@row), 0)

https://app.smartsheet.com/b/publish?EQBCT=43549d458f7b4ba89bd1a4d295b558a8

BrendonP12222

Thank you so much! This worked perfectly!

jmyzk_cloudsmart_jp

Hi @BrendonP12222

I would change the Suffix formula as follows;

=MATCH(UniqueID@row, COLLECT(UniqueID:UniqueID, [Parent ID]:[Parent ID], [Parent ID]@row, Department:Department, Department@row), 0)

https://app.smartsheet.com/b/publish?EQBCT=43549d458f7b4ba89bd1a4d295b558a8

BrendonP12222

Thank you so much! This worked perfectly!