Auto Numbering / System Prefix/Suffix
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
MARLANA KALINOWSKI
Sr. Business Analysts / Smartsheet Solutions
National Pharmacy Services | Genoa Healthcare
Answers
-
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
-
@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.
MARLANA KALINOWSKI
Sr. Business Analysts / Smartsheet Solutions
National Pharmacy Services | Genoa Healthcare
-
yep. cumbersome.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives