Auto Number to Reset Daily (PO #)

Options
MCorbin
MCorbin Overachievers Alumni

I'm trying to create a PO #. They want to include the date and a sequential number in the PO #, e.g.

2020031100005

2020031100006

I can use the "Auto-Number" function, BUT... they want the number to reset back to 1 for the next date... which auto-number doesn't do.

Is there a way to do a running count that would basically add a number for each row added on a given day?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!