Formula to increase a unique Id number that uses text and numbers

[Stryfe]

Hello,

Thank you for taking the time. I've approached this from a lot of different angles and still keeping hitting a wall getting my desired outcome.

I've created a form for Lab Requests and at the end of submitting the sheet, it will record the data in a log and clear the sheet. I have the Lab Request number generate when the first date is entered. The format I use for identifying Lab Requests is simple LabReq-0001.

The problem I have is that it displays as LabReq-1. I've given up on trying to get it to pull the next available number from the record. I would really for it to pull the next number from the existing record + 1. What I currently have resorted to is using Concatenate where I break down the last record number and still can't get it to display four digits.

Would love some ideas because I'm hitting a wall.

[JohnTopley]

="LabReq-" &TEXT(A2,"0000")

where A2, A3 etc = 1, 2, 3