Sort a Join/Collect formula?

In a sheet, I have a helper column that concatenates the date and budget columns. Then a field in the sheet summary that uses JOIN COLLECT to list that data. Is there a way that I can have that listed data be sorted by date?

In case this helps, here are some screen shots - Helper column

Output of the Join - collect formula in the sheet summary:

Thanks in advance for any help you can provide!

Find more posts tagged with

Formulas

Accepted answers

All comments

Jgorsich

It wouldn't be elegant, but if you added a rank column (or two, if you are worried about more than 1 row having a single date, you just need to append something to the first rank that breaks ties and then rank again) you could then add another helper column of your concatenated date/value data but now index(matched()) against the ranking so that it would be in the order that you want. Then when you do your final join(collect()) you can run it off of the ordered data instead of the unordered.

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.