so I am very ameature in google sheets. I am an artist and I am organizing stock. In google sheets I have title, price, medium, sold/not sold, etc... I have print series that go up to 100. for example "hummingbird 1/100" then the next row is "hummingbird 2/100" the next is "hummingbird 3/100" and I am trying to create a sequence so I don't have to type it out every row. help please, thank you so much for your time.
If you need exactly the value, the string "hummingbird 12/100", then a formula like
="hummingbird " & (ROW()-2) & "/100"
(In this case, 2 is the row number before the start of the list)
If you just want to see such a line, then use the cell formatting capabilities - fill the cells with only serial numbers 1,2,3 and so on and then apply a custom number format
"hummingbird "0"/100" to them