Dynamic View and calculated fields
I am currently setting up a status workstream tracking process using a combination of Smartsheet and Dynamic View.
The Smartsheet tracker uses the WEEKNUMBER of the Created By date to show the 'Update Week', ie the week the update was entered, and WEEKNUMBER(TODAY()) to show the current week, in the following extract from the Smartsheet the 'Update Week' is 35 and the 'Current Week' is 39.
My plan is for workstream owners to only add updates via Dynamic View so I wanted them to be able to update existing information while it is still 'live' in the current week, and add new updates when the week changes. To do this I display the 'Update Week' and 'Current Week' in Dynamic View as shown in the following, the problem is the 'Current Week' appears as the week the entry was originally made, not the current week shown in the underlying sheet.
Am I doing something wrong, or is Dynamic View not actually updating dynamically?