Properly sort months in AppSheet

preview_player
Показать описание
Ordering or grouping dates by month or weekday is not intuitive in AppSheet. Use this trick to allow sorting or grouping by the calendar order.

The formula created in this video:

switch(
[Month No],
1, Jan,
2, Feb,
3, Mar,
4, Apr,
5, May,
6, Jun,
7, Jul,
8, Aug,
9, Sep,
10, Oct,
11, Nov,
Dec
)
Рекомендации по теме
Комментарии
Автор

I ended up getting a question mark with a box when copying. It wasn't invisible.

Drona
visit shbcf.ru