Auto Numbering / System Prefix/Suffix

Marlana K.

I have a Auto Numbering Column setup as a Reference number for inquires for a form submission request. I know that a year can be entered for the prefix or suffix by placing {YYYY} but is there a way to reference a certain column by adding {{column name}}? 

Thanks!

Marlana

Deric

If you want more flexibility, use an Auto Number column and a helper column to create whatever key id that you want.

=[Auto Number]@row + "- " + Animal@row

Marlana K.

@Deric Thanks for your reply. I was trying to avoid one more "helper" column. Seems like that is the ongoing resolution for many things and all the extra columns are cumbersome. I can sometimes hide the columns for my clients that I build these for but then when I have to do any kind of maintenance I have to unhide and re-hide them.

Deric

@Marlana K.

yep. cumbersome.