At some point there was a problem with week numbering. Looks like I removed the formula in this version.
You may find the correct formula when following this:
Please can you click on the cell where this occurs, and send a screenshot of the page.
I don’t have 2022-52 in my original ATP spreadsheet, so it could be wrong in the file where we’ve merged all tabs together.
[image]
I am using ISOWEEKNUM in the formula.
WeekNum uses the week containing January 1 as the first week of the year. The result from this function can range from 1 to 54. ISOWeekNum uses the week containing the first Thursday of the year as the first week of the year. This follows…
The formula I use, is as follows:
=IF(G25="","",IF(YEAR(A25)<>YEAR(A26),YEAR(A26)&"-"&ISOWEEKNUM(activities[@[start_date_local]]),IFERROR(IF(activities[@[start_date_local]]="","",IF(C25<10,YEAR(activities[@[start_date_local]])&"-0"&C25,YEAR(activities[@[start_date_local]])&"-"&C25)),"")))
[image]