Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Sorting- not sorting as expected

304 4
Showing results for 
Search instead for 
Did you mean: 

It appears as if some records in field have a space before, so it doesn’t sort correctly. How do if fix it?

4 Replies 4

Hi Jeff. What kind of field? If it’s a text field, create a new formula field right beside it. Then make the formula TRIM({field from which to remove whitespace}). Then copy paste the formula column back into the original field column. Then delete the formula field (you don’t need it anymore). Make sense?

If it’s another kind of field, you might need a different intervention.

It is the primary field, single line text

Thank you. I got the trim column done, but how do i copy/past this column back into original field?

I got it. thank you again