Forum Discussion
Gogi_Putkaradze
Apr 21, 2022Copper Contributor
Formula calculated column: show date as week number
I have the following issue in SharePoint List: I have a column name SalesWeek and I want to show in another column named "WeekNB" the week number. In short show 4/21/2022 in Salesweek as week ...
SvenSH
Jul 24, 2024Copper Contributor
Following up on this topic, I tried implementing this logic into our Sharepoint online but realized, that calculated column values are static and only update, when the item is updated. As we want to use this calculated column as a basis for a filter (e.g. for showing only the list items that have their [start_date] column set to the current week), we would need to implement this with a more dynamic approach (which would be JSON I assume).
Any idea how a formula for JSON would look on a NUMBER column, that extracts the week number from another DATE column and calculates it dynamically?
Any idea how a formula for JSON would look on a NUMBER column, that extracts the week number from another DATE column and calculates it dynamically?