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
Tags:
Answers
-
Hi @Jen R
Hope you are fine, did you mean that you will use the Row ID as a reference to create the 25 rows. (Batch Column)?
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
I could use the row as the reference as long as the Row ID does not include rows with a blank cell in the Grid column
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!