How to Identify Skipped Number
Options
Brian Cianciolo
✭✭✭
I have a column containing document numbers that looks somethin like this:
s001
s002
s004
Does anyone know of a formulas that I could put in the sheet summary to return the first skipped number (in this case, s003)? I know how to do this with a "helper column", but I'd like to avoid that if possible.
Tags:
Best Answer

The only way I can think of is with a helper column.
Answers

The only way I can think of is with a helper column.

Thank you, @Paul Newcome.
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!