Formula Help with Job Number Creation

Hi! Quick question for everyone. I would like it when a new item is created, have a formula column generate a job number. Job number is equal to YYMMXX where XX is a count that resets to 01 on the first of every month.

3 Likes

Good luck with this!!! This has to be a Monday new column to fix that.
What we really need is a Custom ID column por pulses.
For more information see this previous requests:
https://community.monday.com/t/custom-numbering-of-pulses/855