This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

1
So I want to create custom IDs
Post Body

I have a column for IDs already and some rows already have IDs in it and I want to create custom IDs for the new rows based on the business unit which contains either HR, FIN, AP or SCM and the format of the id should be OMM_HR_0001 and if the next row's business unit is AP, it should be OMM_AP_0002 I've tried formulas but I get #unparseable. Any tips?

Author
Account Strength
60%
Account Age
10 months
Verified Email
Yes
Verified Flair
No
Total Karma
526
Link Karma
53
Comment Karma
473
Profile updated: 1 week ago
Posts updated: 1 day ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
2 months ago