Return "Next" when the row above in primary column is not blank and row below is blank

kharrison ✭✭
edited 01/08/24 in Formulas and Functions

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!