Hi Rich, great video, I'm trying to implement this and finding that its arranged in order, but in front of the month it is showing a Mar, any ideas what i'm doing wrong?
damn. what an epic trick. if i need to take year into account as well for the grouping, how would you go around it? what im doing today is grouping by a virtual column that calculates "yyyy/mm". not ideal because it looks ugly.
You can probably place a character in front of the month empty character that would represent the year. Ie. Comparing Jan '22 and Jan '23. Use [1][1]Jan '22 and [2][1]Jan'23 respectively. Where [1] and [2] represents the first and second empty character from the character map. The virtual column formula would be switch( year([date]), 2022, [1], 2023, [2], Etc and concatenate that onto the month formula. Appsheet should sort by the first character so all of 2022 first, then by the second character which would be the month.
Wonderful tip but I have problem on iPhone
Showing some character.
You can also copy those characters in the last section of the video into google sheets database to complete the same task. :)
Hi Rich, great video, I'm trying to implement this and finding that its arranged in order, but in front of the month it is showing a Mar, any ideas what i'm doing wrong?
damn. what an epic trick. if i need to take year into account as well for the grouping, how would you go around it? what im doing today is grouping by a virtual column that calculates "yyyy/mm". not ideal because it looks ugly.
You can probably place a character in front of the month empty character that would represent the year. Ie. Comparing Jan '22 and Jan '23. Use [1][1]Jan '22 and [2][1]Jan'23 respectively. Where [1] and [2] represents the first and second empty character from the character map.
The virtual column formula would be
switch(
year([date]),
2022, [1],
2023, [2],
Etc
and concatenate that onto the month formula.
Appsheet should sort by the first character so all of 2022 first, then by the second character which would be the month.
"Promosm" 💖