What is a good formula to use to identify a gap in sequence?

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!