I currently have a sheet populated via a web form. There are several people assigned to tasks.
My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible.
Lets say I'm assigned a task, the number format would show as: LS-XXXX-268790