# Need an autofill number

Hi,

1) I need a formula, which can fill number automatically

Ex: series of num 1,2,3..... if i select a cell next number should come automatically!!!

2) Two coloumns A & b, If I select a cell in colounm A , automatically another cell should autofill in column B.

EX:

Green, Blue, Red-----Coloumn A

8h, 10h, 24h------- coloumn B

IF I select Blue in A column , 10h should autofill in B colounm,

• ✭✭✭✭✭✭

The formula above should work in the dropdown.

As for the series... Are you able to provide a screenshot that shows what you are trying to accomplish?

• ✭✭✭✭✭✭

You would use a nested IF statement for your provided example. Something along the lines of this in Column B...

=IF([Column A]@row = "Green", "8h", IF([Column A]@row = "Blue", "10h", IF([Column A]@row = "Red", "24h")))

• Thanks for writing paul,

It is working fine...

How to write same formula for dropdown??(Green, blue, Red) in dropdown in column A and (8h,10h,24h) in dropdown in coloumn B.

1) I need a formula, which can fill number automatically

Ex: series of num 1,2,3..... if i select a cell next number should come automatically!!!

)

• ✭✭✭✭✭✭

The formula above should work in the dropdown.

As for the series... Are you able to provide a screenshot that shows what you are trying to accomplish?

• Yeah paul, that works absolutly fine now...

1) I need a formula, which can fill number automatically

Ex: series of num 1,2,3..... if i select a cell next number should come automatically!!!

Thanks...

• ✭✭✭✭✭✭

Are you able to provide a screenshot with manually entered data that shows what you are trying to accomplish?

• Hi,

Numbers are in 0001,0002,0003,.... the arrow showing cell should auto fill i,e 0006 should come if I click the cell.

• ✭✭✭✭✭✭

You can insert an auto-number column and then put the leading zeros in the "Fill" field. It won't automatically populate when you click on a cell, but it will populate on each row as you insert new data.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!