WEEKDAY column type for common use cases

[Lindsey_Lindow]

The addition of a WEEKDAY column type would be immensely valuable, especially for sorting and grouping records by chronological weekday order (e.g., Sunday, Monday, Tuesday, etc.). Currently, AppSheet does not provide a straightforward way to achieve this.

Creating a virtual column to return weekday values as text is manageable, but problems arise when attempting to sort or group the column in chronological order. Since the virtual column returns a text string, the result is alphabetical sorting (e.g., Friday, Monday, Saturday, Sunday, Thursday, Tuesday, Wednesday), which does not align with the natural sequence of weekdays.

AppSheet does not recognize the sequential order of weekdays unless users explicitly define it. To address this limitation, users must resort to cumbersome workarounds, such as: 

• Additional virtual columns with numeric prefixes.
• Child tables with predefined weekday sequences.
• Advanced expressions.

These workarounds add unnecessary complexity in common use cases like timesheets, scheduling, and reports. A dedicated WEEKDAY column type would be an intuitive and streamlined solution to enable chronological weekday sorting without the need for extra setup.