Formula to Auto assigned Id_Number as Input in Sheet
What Formula should I used get desired JV number output
> Here In Sheet I what to get out similar as shown in JV Number column, Point to be note number id in JV number should be assign as per entry in sheet.
1) So Here in variation# column the entry is against variation num. VAR0012814 so number assign to it should be JV001, now whenever new entry is done with same variation number again at any position in sheet the JV number it should get JV001.
2) Next entry in Variation# column is VAR0012816 , VAR0012817 and so on. in reference of these entry JV number output should follow same pattern as shown in picture.
Answers

You may have to create a "helper" sheet with the variation numbers on it in one column, and the corresponding JV # next to it. Then do a vlookup to that sheet as your formula in the JV column.
Your "helper" sheet could just have these 2 columns:
Then your formula back on your main sheet could look like this. I converted it to a column formula so that any new rows added would automatically have the formula. Also, as a best practice, I typically lock my formula columns.
Hope this helps!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 429 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!