I want to lock a formulae for auto-increment


Untitled.png

I have manually added these values on row column

Is there any way I can make this a column formulae?

Although the whole point of this is to get the ID from another sheet.

I tried and I just want to create a formulae that gets this ID from another sheet, whenever it is added

Please note that I have used reference sheet name as ID.

For Example:

= {ID}@row or ={ID}1

But I am unable to do that. Therefore, I have to create a column by name row and add values to it.

Then using index function I get values from another sheet within ID column

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!