Row ID (ignoring blank cells)

I am trying to create a sheet which identifies batches of 25 rows and creates a specific batch ID, before moving onto the next 25 rows. (Batch Column)

I also need to formula to ignore rows with blanks entries. (Row ID)

I hope somebody is able to help

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!