Return "Next" when the row above in primary column is not blank and row below is blank
Example based on the image: if column "ID" row 2 is not blank and column "ID" row 4 is blank, then column "Next" row 3 will say Next and all other cells will be blank. This will be ongoing so needs to be a column formula so I can assign the Next available license.
Note: I've been going at it for days using the community pages and tried various suggestions and deleted them all when they didn't work so I don't have any formulas or error messages to share. But I do appreciate your help and hope my explanation and image help tell the story.
Help Article Resources
Check out the Formula Handbook template!