Creating a PO # using todays date

damon.tackett

I am looking for a formula or would allow me to create PO# using todays date. I need it to end up looking like this if I create it on 02/20/2025: PO022025

Any thoughts on how to make that work?

Paul Newcome

You would insert a Date Created type column and then use

="PO" + RIGHT("0" + MONTH([Created Date]@row), 2) + "" + YEAR([Created Date]@row)

damon.tackett

Thank you Paul! That worked great! I needed the day in there as well so I just updated it to

="PO" + RIGHT("0" + MONTH(Created@row), 2) + "" + DAY(Created@row) + "" + YEAR(Created@row)

and it gave me exactly the result I needed.

Paul Newcome

Sorry about that. I saw "2025" and assumed it was full year as opposed to ddyy. Glad you got it sorted.

Paul Newcome

You would insert a Date Created type column and then use

="PO" + RIGHT("0" + MONTH([Created Date]@row), 2) + "" + YEAR([Created Date]@row)

damon.tackett

Thank you Paul! That worked great! I needed the day in there as well so I just updated it to

="PO" + RIGHT("0" + MONTH(Created@row), 2) + "" + DAY(Created@row) + "" + YEAR(Created@row)

and it gave me exactly the result I needed.

Paul Newcome

Sorry about that. I saw "2025" and assumed it was full year as opposed to ddyy. Glad you got it sorted.