Numbers sorting improperly in CRM

Smart CRM & Sales Hub CRM
1

snip tool.PNG
snip tool.PNG1072×486 42.2 KB

Consider above photo.

Date granted increases first by month, then day, then year instead of first year, then month, then date. I suppose this could be fixed by reordering dates, but it should be fixed regardless.

PE Number (ranging from 6,000 - 127,000) has trouble sorting because the number with the [most characters + ascending order] is sorted before those that are a real lower number. (E.g. Sorting down outputs: 100000, 100001, 100002, …127000, 6000, 6001, 6002 instead of 6000, 6001, 6002, …127000)

Any fix to this? Please and thank you.

2

Are the data types of both properties date and number, respectively? PE Number sounds like it’s being sorted as text, and Date Granted might be, as well.

If you do need to change the data type of these custom properties, please review this help article. This has the potential to erase all preexisting values in the property, so you’ll want to export values first, then reimport after making the property data type change.

3

That was percisely the issue. Thank you!