Auto-numbering with formula

Anoop Phago
Anoop Phago ✭✭✭

I am reaching out to seek your assistance regarding auto-numbering.

Screenshot 2023-11-01 135145.png

Here's the situation: I have a smartsheet file where one of the columns is the location, i.e., Nepal (NP), Pakistan (PK), and India (IN). And the second one is auto-numbering (where I need a formula) Now in the auto-numbering column, I want a formula so that the auto-numbering is based on the location as the rows are added, like for Nepal, the auto-numbering should go like NP-01, NP-02, NP-03, and so on.

Answers