I have a list and I wanna sort by bithday, however, the system type โdateโ will sort by the year. can i just show the month and date only? I wanna sort by month then i can check my list, my friends, by their month.
ex. sort by date
Emily 1992/5/5
Amy 1993/1/5
Amy is in JAN, Emily in MAY, but the list will list by the year they born.
This requires including additional fields, one for each separate piece of data you want to record - even when that data is a duplicate.
For instance, Iโll typically have the following fields for any sort of data-capture tables:
Even though the 2nd and 3rd columns are duplicates of whatโs stored in the first, itโs helpful to have them separated out like this.
Sorry, I am a beginner, I couldnโt understand, how can i solve the problem?
No worries.
What Iโm trying to say is, if you need to see something grouped by a specific piece of data (say the date, or the month of that date)โฆ
So in your example, you want to be able to group by monthโฆ so include a Month column with a formula like the following:
INDEX(
{
"January", "February", "March",
"April", "May", "June",
"July", "August", "September",
"October", "November", "December"
},
MONTH([DateTime])
)
Then you can group by that column instead.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |