Looking for formula to concatenate the current count of a linked record to its name

[John_Young]

Currently trying to create a formula that shows the count of a record. (i.e. first record will have a value of 1, second record linked to the same data will have a value of 2)

See attached picture for ideal / expected output:

Is there a formula you might suggest to achieve this? (The red-colored numbers is what I want)

[Kamille_Parks]

You’d follow a similar process as described here:

Auto-Number New Records with Prefix Ask the community

Hey all. I’ve searched a handful of times but can’t seem to find another example of what I’m trying to accomplish. I’m looking for some help with an automation or script that can automatically add the correct inquiry number. We do this manually and it’s slowing down our response time and ability to, well automate processes. Our inquiry numbers syntax: YY-NNN or an example: 21-846 The next inquiry would be 21-847. This being the two-digit current year as a prefix and then just an integer of t…

Instead of creating a new formula field for the year, you’d create one for {full_name}'s last name.