OVERFLOW BECAUSE of CHARACTER LENGTH

JonahD.

Hi I'm having an error because of the character length of my "Account Number" that will be the basis need to get the highest/latest "Service End Date" every row. Here's my formula:

=MAX(COLLECT([Service End Date]:[Service End Date], [Account Number]:[Account Number], [Account Number]@row))

Jason Albrecht

Hi @JonahD.

Is it possible / worth while creating a helper Account Number column that uses =RIGHT([Account Number], 5) for the last 5 digits (or how ever many numbers up to 12) of the Account Number?

Your formula could then reference the helper column instead.

Thoughts?

Jason Albrecht

Hi @JonahD.

Is it possible / worth while creating a helper Account Number column that uses =RIGHT([Account Number], 5) for the last 5 digits (or how ever many numbers up to 12) of the Account Number?

Your formula could then reference the helper column instead.

Thoughts?