I want to send a summary of tasks automatically each week. I know there must be a button to do that that can be triggered every friday through a normal automation. I just don't know how to do it.
Also, I want the bulletes list of "tasks completed" to be generated automatically when the status of "All Tasks" changes to "Done". I tried this formula: [All Tasks].Filter(People= [Angel Diaz]).filter(Status=Done). Filter([Due date]>(Today())). BulletedList() but it doen't work
All tasks
Not Started
0
In Progress
0
Done
3
Not Started
0
In Progress
0
Done
3
Task 1
Task 2
Task 3
Weekly Task Status Update
Summary of tasks:
@Task 1
@Task 2
@Task 3
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (