Order of days of the week

[Miranda_Lubarsk]

Hi guys -

So I have a de-ref that pulls in the [Scheduled Day of the Week] from another spreadsheet, via the Key, [Client Name].

This works.

However, I’m trying to display this in a view so that I have everyone’s schedule together, and the only option is for the order to be ascending or descending, which results in a weird order that does not make sense. I want the order to be: Monday, Tuesday, Wednesday, Thursday, Friday.

How do I accomplish this?
Thanks,
Miranda

[SkrOYC]

Post here your expression to help.
Anyway, the only way for now is by adding a number at the begginning.
Example:

Months	Days on a week
01-January	01-Monday
02- February	02-Tuesday
…	…

[Miranda_Lubarsk]

Seriously??? There has to be a better way! this would majorly mess things up for us. Please tell me about something better.

[SkrOYC]

Well, it depends.
If you want it sorted inside the app, there is no better way I know.
If you want to show sorted items from an expression that returns a list (for a template, for example), you could use ORDERBY() and order the items using another column as @Austin_Lambeth said.
Where you need to sort the data?

help.appsheet.com

ORDERBY()

Sort row references

[Steve]

Create an Enum column. Set the column’s allowed values. Order the allowed values as desired. Store the derefed values in this column. Sort the view on this column.

This is why Enum columns allow you to order the allowed values: to set the sort order.

[SkrOYC]

Does this apply for suggested values instead of hardcodded into the config?

List(
  "Monday",
  "Tuesday",
  "Wednesday",
  "Thursday",
  "Friday",
  "Saturday",
  "Sunday"
)

[Steve]

I don’t believe so.

[Miranda_Lubarsk]

Steve, you son a gun! the best!!

[Austin]

Feel like a weekday column type would be nice.
Can make a VC that takes day of week and turns it into a number then sort on the vc. I don’t know if the VC has to be on the table but could put it as the last column.