Auto Number: possible to generate Project IDs in Smartsheet?

Paul Newcome

@Nguyễn Hà Anh Are you trying to get a WBS in place?

Nguyễn Hà Anh

@Paul Newcome Yes, thanks I have booked a Pro Desk session and the issue went well finally.

Paul Newcome

@Nguyễn Hà Anh Glad that you got it working. I'm not sure of the specifics for the Pro Desk's solutions, but HERE is the solution I typically use when building out a WBS.

Are you able to post their's? I am always interested in alternatives.

Andrée Starå

@Nguyễn Hà Anh

Excellent!

Glad you got it working!

Also, I agree with Paul. It would be great if you could share how you solved it.

Nguyễn Hà Anh

So after a Pro Desk session, this is a template for solutions that I got.

For RowID, I use =COUNT($Level$1:$Level@row)

For Level: =COUNT(ANCESTORS()) + 1

Numbering: =IF(Level@row = 0, "", (IF(Level@row = 1, COUNTIF(Level$1:Level@row, 1), "" + PARENT() + "." + COUNTIFS(Level$1:Level@row, Level@row, RowID$1:RowID@row, >(PARENT(RowID@row))))))

Hope this helps.

Andrée Starå

@Nguyễn Hà Anh

Excellent!

Thanks for sharing!

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!