There is no week 1 !
week column is formula weeknum({Date})
There is no week 1 !
week column is formula weeknum({Date})
And to complete, the “group by week” is working differently than formula week number.
See the 21/02/2021 that is labelled as week 9 in the colum, but grouped with week 8 items
We should have an option for week numbers, as there are multiples case :
An option to choose the first day of the week would also be great
EDIT : in addition, it would be GREAT to have to option to not sum the grouped items. i don’t want to sum up week numbers repeated
Hi, if you have looked into the description of the function weeknum()
you should have seen this:
Apart from that, we also have a full list of all the functions in the SeaTable Manual - Formula Reference:
Write your formula like weeknum('2021-01-03', 'monday')
and you’ll get week 1.
And for your second post: the error is caused by the fact that SeaTable takes Sunday as the start of a week automatically when grouping. Users should have the option to choose the starting day of the week. This is surely a thing that should be improved, so thanks for the report!
Thanks,
I’ve seen indeed the option of Monday as week 1, but actually, I must cheat to get the good weeknumber in european format on 2021.
I can’t get the ‘first week with 4 days’ by just pointing the starting day of a week.
And even then, there is something wrong, eg with the table.
Formula is weeknum({When},“Monday”)
Week 1 lasts only 4 days ?
Hi, no big deal.
Oops, this is a bug, good call!
The first 3 days don’t belong to Week 1 in 2021. I have to report this…
Indeed,
In france, week 1 is from 4th to 10th January
There may be less surprises with a set of ISO 8601 time/date functions. See as well https://en.wikipedia.org/wiki/ISO_week_date for the week-date.
Indeed, at this stage, it seems that the main chronological structure lacks a bit of polish or guideline.
You are absolutely right! SeaTable is only 0.5 years old, there’re surely things that still need polishing. We are polishing already
And you do it well !
I really appreciate the detailed feedbacks and the way things are going on.
Hi Ben,
could you please check the weeknum function again?
The problem should have been fixed.
My problem is fixed with the new formula isoweeknum (this one works as I needed)
However, the weeknum function is still broken, see the screenshot:
1st left column is the isoweeknum formula
2nd column weeknum
Date is in ISO format
with weeknum, week 52 has 7 days, week 53 has only 5 days and week1 only 2 days…
but isoweek is ok
best
I am not sure I understand you.
The isoweeknum seems to be doing exactly what it is supposed to do, and so does the weeknum formula. Keep in mind, you can set the return_type in the weeknum function. When set to 1 (default), a new week starts on Sunday; when set to 2, the week starts on Monday.
@Karlheinz Could you add the isoweek function to the “Formelreferenz”?
Hi,
thanks for clarification
the weeknum is so far from my use case that i can’t see a reason for this .
but anyway, it’s ok with the isoweeknum so consider as closed
Do it like thousands of other people who have used SeaTable to develop powerful processes and get their ideas and tasks done more efficiently.