I have a SharePoint list I need to create a column to be used as ticketing system. I was thinking a simple text + ID column. The field can be hidden, the users do not need to see it. This will be for reporting only when they export to excel.
I know the ID only generates after submission so how can I still get the text + ID and what is the concat formula for it? Thank you.