What is a good formula to use to identify a gap in sequence?
Options
I've created a sheet that tracks the check sequence used for each of the clients that we manage. I have the following columns: client, check date, beginning check number, ending check number, and upload date.
What is a good formula to identify a gap in the check sequence by the client? Each client has their own check sequence.
Answers
-
How is your data stored? Is it on a separate sheet or same sheet? Is it just a list of check numbers?
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!