Gallery
Burndown
Share
Explore
Gallery
Burndown
Snapshots

ForEach Working space

Guide:
https://coda.io/@simpladocs/foreach
⁠
⁠

Add list of tasks


⁠
Click me
⁠
⁠
Tasks.ForEach(AddRow(Log,Log.[Task name],CurrentValue ))
Log_Step1
Task name
1
Task 1
2
Task 2
3
Task 3
4
Task 4
5
Task 5
6
Task 6
There are no rows in this table
⁠

Add all data points

⁠
Click me
⁠
⁠
ForEach(Tasks,
AddRow(Log_Step2,
Log_Step2.[Task Name],CurrentValue,
Log_Step2.[Points remaining],[Points remaining],
Log_Step2.[Date stamp], Today()
))
Log_Step2
Task Name
Points remaining
Date stamp
1
Task 1
0
8/21/2024
2
Task 2
1
8/21/2024
3
Task 3
2
8/21/2024
4
Task 4
4
8/21/2024
5
Task 5
​
8/21/2024
6
Task 6
​
8/21/2024
There are no rows in this table
⁠

Filter, then add

⁠
Add tasks to log
⁠

⁠
[F] Add tasks to log
⁠
⁠

//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())
)
)
Log_Step3
Task Name
Points remaining
Date stamp
Sprint
1
Task 2
1
8/21/2024
Sprint B
2
Task 3
2
8/21/2024
Sprint B
3
Task 4
4
8/21/2024
Sprint B
4
Task 5
13
8/21/2024
Sprint C
5
Task 6
5
8/21/2024
Sprint C
There are no rows in this table
⁠

Gallery
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.