Skip to content
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
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 ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.