Graphic Archive Numbering Concatenation

edited 12/09/19 in Smartsheet Basics

I am trying to figure out how to connect a number of columns to output a number into a new column. We have a need for a graphic archive number that could combine all these elements. artist name, creation date, and a numerical counter. 

So, if Joe Artist makes a new graphic on August 1st, 2018, and its his twelfth graphic of the day, it would take the artist/date columns and concatenate it to JA060118, and then see that this code has been used 1 through 10 and name this one JA060118-11. 

Is this possible with smartsheets?