Hello I am trying to make an invoice number in the format TYYYY-MM-XXX
where X is a random number.The formula I am suing is CONCATENATE("T",
YEAR(NOW()),"-", MONTH(NOW()), "-", RANDBETWEEN(100,999) )I am getting
T2022-2-123 as an exampleThe problem i...