Is there a way to create a WBS formula that produces only whole numbers

Berto D
Berto D ✭✭
edited 08/25/22 in Formulas and Functions

I need a WBS formula that produces numbers that will be nothing more than 1, 2, 3,.... 878, 879, etc., regardless of indents and outdents.

I don't want, for example, ""

Is this possible?

The reason I ask for a WBS-like solution is because if I rearrange the rows, I want the calculation to adjust accordingly. So if a task 872 gets moved up to three tasks above it, the new number will be 869.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!