Auto-number based on selected category for project ID
I track all projects under ~7 programs in a Smarsheet. I have auto-numbering on for the column, but it numbers new projects at "PT135" or whatever. I'm looking for a way for it to only auto-number based on the selected program, so if I select Beverage, the project ID will be "BEV135," or an edible would be "EDB123." Is there a workaround that could help me achieve this without doing it manually?