Sorting Queried Data in Descending Order

Hi Everyone,

I was wondering if there is a way to sort queried data in descending order. I'm aware there is no explicit SORT function and the way I set up my data sheet, I am unable to sort the rows/columns that way.

The formula I am using is as follows:

=JOIN(COLLECT({Domain}, {Status}, "DONE"), CHAR(10))

This is retrieving a list of domains where the status is DONE. Is there anyway in this formula to sort the domains in descending order as they are represented by numerical values?

Thank you for your help.

Find more posts tagged with

Accepted answers

All comments

kowal

hi @egold31,

Why the built in column sorting is not working for you?

Paul Newcome

How many domains are there that you would need to sort in a single JOIN function?

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.