Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 22, 2024 11:14 AM
Hi all, I was wondering if you could help me create a formula that would output an alphanumeric ID based on variables in other cells in the row. I'd like to create an ID that include:
- First, if Cell A = xYx then add "Z" to start. If Cell A = YxY then add "ZD" to start.
- Then, take first letter from name and surname, and then add these. So John Smith becomes JS
- Then, add first 4 digits from date field (DOB). So, 14/11/1980 becomes 1411
So, as an example, ZDJS1411.
Thanks so much community!
Solved! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 23, 2024 02:41 AM
Does this look right?
SWITCH(
{Cell A},
'xYx', 'Z',
'YxY', 'ZD'
) &
LEFT(
{First name},
1
) &
LEFT(
Surname,
1
)&
DATETIME_FORMAT(
DOB,
"DDMM"
)
2 Replies 2
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 23, 2024 02:41 AM
Does this look right?
SWITCH(
{Cell A},
'xYx', 'Z',
'YxY', 'ZD'
) &
LEFT(
{First name},
1
) &
LEFT(
Surname,
1
)&
DATETIME_FORMAT(
DOB,
"DDMM"
)
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 23, 2024 08:04 AM
Wow... Yes, that absolutely does! Thanks so much Adam.
Reply
