# Sorted table view moves on its own **URL:** \ **Category:** Report a Bug\ **Created:** [June 13, 2024, 3:45am UTC](https://community.glideapps.com/t/sorted-table-view-moves-on-its-own/74094 "2024-06-13T03:45:55Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![dtks](https://avatars.discourse-cdn.com/v4/letter/d/7bcc69/32.png) [@dtks](https://community.glideapps.com/u/dtks)\ **Post date:** [June 13, 2024, 3:45am UTC](https://community.glideapps.com/t/sorted-table-view-moves-on-its-own/74094/1 "2024-06-13T03:45:55Z")
Team ID [https://go.glideapps.com/o/rRpDhBDfOv7O18IXTEca](https://go.glideapps.com/o/rRpDhBDfOv7O18IXTEca) App ID [https://go.glideapps.com/app/xlnysspMG23TIJgDZFpD/layout](https://go.glideapps.com/app/xlnysspMG23TIJgDZFpD/layout) Hi all Basically I have a table view with a sort based on expiry date. This expiry date made using the “date difference” column. The sort is correct. However, every few seconds, the rows will shift. It’s still correct in that the entries with the same expiry date will be together, but their order will just move randomly. And it always happens. Both in the player view and published app view. The following screenshots are made a couple of seconds apart. ![Screenshot 2024-06-13 at 11.37.49 AM_Redacted](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/e/ae333fba43fa31ae29558dedb8850ff4e1f4ddd2.jpeg) ![Screenshot 2024-06-13 at 11.37.55 AM_Redacted](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6f94d7bdf3746c10a3bbed8a2bff5056283de1ed.jpeg) It’s not a big deal, but it does make me lose track of what I’m doing, and visually it’s just really distracting. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 13, 2024, 3:55am UTC](https://community.glideapps.com/t/sorted-table-view-moves-on-its-own/74094/2 "2024-06-13T03:55:51Z")
Try using a math column instead of a Date Difference column and see if that makes a difference. ---
**Author:** ![dtks](https://avatars.discourse-cdn.com/v4/letter/d/7bcc69/32.png) [@dtks](https://community.glideapps.com/u/dtks)\ **Post date:** [June 13, 2024, 4:44am UTC](https://community.glideapps.com/t/sorted-table-view-moves-on-its-own/74094/3 "2024-06-13T04:44:31Z")
Hi Jeff How do it format it right? ![Screenshot 2024-06-13 at 12.43.53 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/8029bb4e6a8dfd25276572f313eb77ac2fc66fed.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 13, 2024, 4:53am UTC](https://community.glideapps.com/t/sorted-table-view-moves-on-its-own/74094/4 "2024-06-13T04:53:22Z")
How does your date difference column handle rounding currently? Would you always round up, round down, or round to the nearest day? If you wrap the math with the appropriate rounding operation, then it will format as a number and you can set the Units (Days). ```auto CEILING(end - today) or ROUND(end - today) or FLOOR(end - today) ``` ---
**Author:** ![aiden55](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aiden55/32/76551_2.png) [@aiden55](https://community.glideapps.com/u/aiden55)\ **Post date:** [June 13, 2024, 4:56am UTC](https://community.glideapps.com/t/sorted-table-view-moves-on-its-own/74094/5 "2024-06-13T04:56:56Z")
> [@dtks](#): > > Team ID > [Glide](https://go.glideapps.com/o/rRpDhBDfOv7O18IXTEca) > > App ID > [Glide](https://go.glideapps.com/app/xlnysspMG23TIJgDZFpD/layout) > > Hi all > > Basically I have a table view with a sort based on expiry date. This expiry date made using the “date difference” column. > > The sort is correct. However, every few seconds, the rows will shift. It’s still correct in that the entries with the same expiry date will be together, but their order will just move randomly. And it always happens. Both in the player view and published app view. > > The following screenshots are made a couple of seconds apart. > > ![Screenshot 2024-06-13 at 11.37.49 AM_Redacted](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/e/ae333fba43fa31ae29558dedb8850ff4e1f4ddd2.jpeg) > > ![Screenshot 2024-06-13 at 11.37.55 AM_Redacted](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6f94d7bdf3746c10a3bbed8a2bff5056283de1ed.jpeg) > > It’s not a big deal, but it does make me lose track of what I’m doing, and visually it’s just really distracting. I can totally understand you because I also had the same issue and it can be very frustrating when the table view is shifting unexpectedly in your app. It sounds like a glitch that might need technical support from GlideApps. I recommend contacting GlideApps support directly with the details you’ve provided, including the screenshots. They should be able to investigate and help resolve this issue promptly. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 13, 2024, 11:05pm UTC](https://community.glideapps.com/t/sorted-table-view-moves-on-its-own/74094/6 "2024-06-13T23:05:15Z")
@dtks Does Jeff’s latest comment help? Can you update us on how it went? Thank you. ---
**Author:** ![dtks](https://avatars.discourse-cdn.com/v4/letter/d/7bcc69/32.png) [@dtks](https://community.glideapps.com/u/dtks)\ **Post date:** [June 14, 2024, 12:03am UTC](https://community.glideapps.com/t/sorted-table-view-moves-on-its-own/74094/7 "2024-06-14T00:03:30Z")
> [@Jeff\_Hager](#): > > `ROUND(end - today) ` It works like a charm! Thanks! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [June 21, 2024, 12:04am UTC](https://community.glideapps.com/t/sorted-table-view-moves-on-its-own/74094/8 "2024-06-21T00:04:00Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.