Hi,
I have a list in which there is a project name, a task description, who (multiple people picker) and a due date
PROJECT | TASK | WHO | DUEDATE |
---|---|---|---|
A | 1 | person1;person2;person3 | 02/25/17 |
A | 2 | person2;person4;person6 | 02/25/17 |
A | 3 | person1;person2 | 02/25/17 |
B | 1 | person4 | 02/25/17 |
B | 2 | person1;person6 | 02/25/17 |
B | 3 | person6 | 02/25/17 |
B | 4 | person1; person2 | 02/25/17 |
C | 1 | person3;person4;person5; | 02/25/17 |
C | 2 | person4;person5 | 02/25/17 |
There can be multiple lines for a project, as many times there are tasks.
I need to send an email 3 days before the due date to the persons in the "Who" column BUT only for the tasks where they appear. I would like to send only one mail which will display all the tasks the person has to complete.
Example: 3 days before "02/25/17", the site workflow is supposed to send a mail to each person in the "who" column.
I assume the mail is sent to person1:
Dear person1,
Please complete the following tasks before 02/25/17 :
Project A
Task 1
Task 3
Project B
Task 2
Task 4
Hope it is clear!
Thansk for your help