Need an autofill number


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.


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

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

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

Please help me

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!