1

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.

2 Answers 2

0

Welcome!

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)

Formula

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

Custom format

Result

1
  • Thank you so much!
    – rob or bob
    Sep 2 at 14:40
0

This formula does not need to be dragged down :

=index("hummingbird " & sequence(100) & "/100")

You will be able to place that formula in any cell of your sheet, as long as there are 99 other free cells below.

1
  • Thank you so much
    – rob or bob
    Sep 2 at 14:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.