Sorting not working?

Hi.

I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap.

Is it a result of the "Next Review Due" column containing a column formula with an IFERROR function?

Here's what I've already tried:

Refreshing the page doesn't correct the sorting.
Re-sorting the sheet by the same column fixes the issue, but I need a better solution than that.
I created the "Sorter" column and sorted that in ascending order to verify whether the issue was caused by my "Next Review Due" column. The same issue occurs when sorting by the "Sorter" column.
I have verified that my fields containing dates are all the correct column type (date).

Screenshot 2025-09-26 at 10.15.37 AM.png

Find more posts tagged with

Accepted answers

Zach_

I just learned that sheets do not auto-sort, so manually re-sorting is the only method for ensuring that you're looking at a sorted, up to date sheet.

I created a report to meet my auto-sorting needs.

All comments

Zach_

I just learned that sheets do not auto-sort, so manually re-sorting is the only method for ensuring that you're looking at a sorted, up to date sheet.

I created a report to meet my auto-sorting needs.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.