nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can you sort by dates in Spreadsheet Table Macro?

Fraser Macmillen

I have a Spreadsheet Table Macro, with a header row and want to sort a set of columns by date which is one of the columns ("Required for"). The sort is only numeric-alphabetical and does not seem to capture date sorting. The result is shown below. Is there a way to sort dates? I guess I can switch to ISO 8601 format (YYYY-MM-DD) as a workaround for now.

Screenshot 2023-11-23 123322.jpg

Accepted answers

Stiltsoft support

Hi @Fraser Macmillen ,

Please visit the "Custom formats" section of the cell format menu in the header of your Table Spreadsheet macro. There you may choose "More date and time formats..." and check which date formats are supported by the macro.

If you apply one of these formats to your cells, you'll be provided with a date picker to insert your dates and you'll be able to sort them as well.

All comments

Stiltsoft support

Hi @Fraser Macmillen ,

If you apply one of these formats to your cells, you'll be provided with a date picker to insert your dates and you'll be able to sort them as well.

Fraser Macmillen

Brill - thank you! That is now working.

Maelle Cartron - Elements

Hi @Fraser Macmillen ! Welcome to Community!

Have you considered trying our app Elements Spreadsheet with the Project Tables macro. You can create table with pre-configured columns (text, date, select list, people, etc.) to help organize your data so it can easily be sorted, managed and analyzed.

With the Project Tables macro, you can easily sort values in the "Date" column and also display a summary metric at the bottom, providing a clear overview of the data.

If you’re interested in exploring this solution further, feel free to reach out. We’d be happy to provide a demo or answer any questions you might have!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

filter

table