Forum Discussion
How to write a formula for generating a number automatically based on year and running number
Do you know the formula for generating a number automatically based on year and a running number?
First of all, there's not a single "the formula" for doing that. There could be several such formulas, with the context in which you want these numbers--which will actually be texts--to appear being a big factor in how the appropriate one would work. Is there going to be a single table in which each new row generates a new serial number as you've specified? Will there be an associated transaction with it--e.g., a new order--and a date for that transaction, such that the date could be drawn from that date?
But anyway, attached is one example of how it could be done. You could keep column B hidden (you'll need to copy the formula down further) and just let it work behind the scenes.