Formula to Create Unique ID on Specific Rows
I am trying to create a unique ID but only on specific rows, so the auto-number column type is not suitable. I would like the ID to be sequential.
I started by generating a number, 1, where Course and Action Due Date are blank. I have successfully done this by using the formula:
=IF(AND(ISBLANK(Course491), ISBLANK([Action Due Date]491)), 1, "")
Not really sure if this is the right approach or where to go next? Perhaps something like If the cell above ISNUMBER, +1 ???
Any ideas appreciated.
Help Article Resources
Check out the Formula Handbook template!