Weekly status template
One click in PullRows Pro adds a Weekly status tab built on your synced Wrike tasks. Formulas only, so it updates whenever the sync runs.
What it shows
| Headline | Definition |
|---|---|
| Open tasks | Status group is Active |
| Overdue | Active with a due date before today |
| Due this week | Active with a due date in the current Monday to Sunday week |
| Completed this week | Completed date in the current week |
| Completed last week | Completed date in the previous week |
Below the headline block, one row per assignee with Open, Overdue and Completed this week. Assignees are read from the synced tab, so new people appear automatically.
What it needs
The synced tab must include the Status group, Assignees, Due date and Completed columns. The sidebar ticks these for you when "include the columns the weekly status template needs" is on, which is the default.
Making it yours
- Change the week start by editing the formula in B2 (it defaults to Monday).
- Add a column for "Completed last week" per assignee by copying the pattern in column D.
- Point a chart at the assignee block. Charts on formula output refresh with the sync.
- Rebuilding the template replaces the tab, so make customisations on a copy if you want to keep them across rebuilds.