How to Identify Skipped Number

Brian Cianciolo
Brian Cianciolo ✭✭✭
edited 03/05/21 in Formulas and Functions

I have a column containing document numbers that looks somethin like this:




Does anyone know of a formulas that I could put in the sheet summary to return the first skipped number (in this case, s-003)? I know how to do this with a "helper column", but I'd like to avoid that if possible.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!