Hey Collective,
I'm trying to create a weekly report and I want the data to update the report autonomously every week from the TOTAL row to the report on a specified date. Is this possible to do?
Data [TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Task List[/TD]
[TD]Investigated[/TD]
[TD]Engaged [/TD]
[TD]Completed[/TD]
[/TR]
[TR]
[TD]Task 3[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 2[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Task 4[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 5[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
Weekly Report
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Progress[/TD]
[TD]Investigated[/TD]
[TD]Engaged[/TD]
[TD]Complete[/TD]
[/TR]
[TR]
[TD]Last Week[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]This Week[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Variance:[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
I'm trying to create a weekly report and I want the data to update the report autonomously every week from the TOTAL row to the report on a specified date. Is this possible to do?
Data [TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Task List[/TD]
[TD]Investigated[/TD]
[TD]Engaged [/TD]
[TD]Completed[/TD]
[/TR]
[TR]
[TD]Task 3[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 2[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Task 4[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 5[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
Weekly Report
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Progress[/TD]
[TD]Investigated[/TD]
[TD]Engaged[/TD]
[TD]Complete[/TD]
[/TR]
[TR]
[TD]Last Week[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]This Week[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Variance:[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]