Snapshots
There’s an that runs a daily snapshot of all the tasks (when you turn it on), but you can also press this button here 👇
Take Snapshot
//Give me the list of tasks that are in the current sprint or future sprint
Tasks.Filter([In current sprint?]=true OR [Future sprint?]=TRUE)
//For each of the tasks in that list
.ForEach(
// Add a row in the Log table
AddRow(Log_Step3,
//Task name is the task object/key (current value)
Log_Step3.[Task Name],CurrentValue,
// Points remaining is the "points remaining" unless the task hasn't started yet, then take the points estimated
Log_Step3.[Points remaining],If([Points remaining]>0,[Points remaining] ,[Points Est.] ) ,
// Date stamp is today
Log_Step3.[Date stamp],Today(),
//And give me the active sprint that the task is in, unless it's a future sprint, then give me that sprint.
Log_Step3.Sprint,[Sprint(s)].Filter(Current=true or [Start date]>Today())
)
)
View of Snapshot
Snapshot Date
Sprint
Task
Status
Remaining points
8/6/2024
Sprint A
Task 1
Active
5
Task 2
Active
4
9
Sum
Task 3
Backlog
10
Task 4
Backlog
4
14
Sum
8/8/2024
Sprint A
Task 1
Released
0
Task 2
Active
1
1
Sum
Sprint B
Task 3
On Deck
10
Task 4
On Deck
4
14
Sum
8/12/2024
Sprint B
Task 2
Active
1
Task 3
Active
5
Task 4
Active
8
14
Sum
8/21/2024
Sprint B
Task 2
Active
1
Task 3
Active
2
Task 4
On Deck
4
7
Sum
Sprint C
Task 5
Backlog
13
Task 6
Backlog
5
18
Sum
77
Sum
Snapshot
Snapshot Date
Task
Status
Remaining points
Sprint
8/6/2024
Task 1
Active
5
Sprint A
8/6/2024
Task 2
Active
4
Sprint A
8/6/2024
Task 3
Backlog
10
8/6/2024
Task 4
Backlog
4
8/8/2024
Task 1
Released
0
Sprint A
8/8/2024
Task 2
Active
1
Sprint A
8/8/2024
Task 3
On Deck
10
Sprint B
8/8/2024
Task 4
On Deck
4
Sprint B
8/12/2024
Task 2
Active
1
Sprint B
8/12/2024
Task 3
Active
5
Sprint B
8/12/2024
Task 4
Active
8
Sprint B
8/21/2024
Task 2
Active
1
Sprint B
8/21/2024
Task 3
Active
2
Sprint B
8/21/2024
Task 4
On Deck
4
Sprint B
8/21/2024
Task 5
Backlog
13
Sprint C
8/21/2024
Task 6
Backlog
5
Sprint C
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.