Starting Number New Each Month

Amber Hall

I use smartsheet as a project management operation for my office.  I'm using the auto-number field to create a request number associated with the request, {YYYY}{MM}-0000.  I would like the 0000 number to start from 1 each new month.  Is there a way to do it other than manually entering in 1 at the end of each month?

JamesR

Amber,

Not using the Autonumber but something could be created to give you that but it would be a calculation and you would not be able to sort or change the order of the rows otherwise it would get messed up.

 

Using the created column and additional ItemNo and ItemRef Columns (see image) and two  formula ( in ItemNo starting on the second row {first row to contain the number 1} =YEAR(Created2) + "-" + MONTH(Created2) + "-" + ItemNo2, in the ItemRef starting on row 1 =YEAR(Created1) + "-" + MONTH(Created1) + "-" + ItemNo1) you could create something,

PMP Manager

Not sure about hoe to do it in auto-numering but if you used the approach above but use a formula in the ItemNo column it could work. In row one of ItemNo manually input 1.  In row 2 use a IF formula =IF(MONTH(Created2) = MONTH(Created1), ItemNo1 + 1, 1). Use the same formula in the post above to compile the reference.  Sorting would present issues if the dates got out of ascending order.