SWOT Analysis Matrix

[R_Felciano_QIAG]

Hi all –

Is there a way to force a sort / ordering of the columns in the matrix block? They appear in somewhat random order. I have column names representing months in a year, and I’d like them sorted chronologically.

Ramon

[Jim_Hare1]

Two years later and I think we’re still missing this, or am i missing something? I need records in the Matrix block to sort as per the view they’re from.

[Bob_Clarke]

Same here. I can get the columns to sort, not the rows. Does not seem to follow the view’s sort settings. Have tried messing with the values (alpha/numerical) and does not seem to follow any logic. Sometimes, I can get the rows to sort correctly and not the columns.

[Bob_Clarke]

Actually, just figured it out. The sorting is not controlled by any view sorting. The sorting is controlled by the order of items in a single select field. Just change their order by dragging each item up and down, save it … and … the matrix app will change. This is actually pretty good as it allows you more direct control of the sorting.

[Kevin_DiBenedet]

Single select order does affect sort order in most places in Airtable. But in a matrix view, you might not always be using that field type. I’m currently using Linked Names, and a schedule of Event. It’s sorting alpha on both the columns and rows. But I have a start time field that I want to use to get everything in date order, but that’s not even a choice that I can use for my columns. Still some hacking with field stuff in order to get it to maybe display how I would like.