Mark Harris
New Member
- Joined
- Aug 7, 2017
- Messages
- 1
Hi,
I have a basic 'action tracker' spreadsheet with the following columns:
1. Action Number (Unique ID)
2. Issue (Free text)
3. Action Required (Free text)
4. Target Date for Completion (Date Field)
5. Category (Drop down list - but effectively free text)
6. Risk Rating (Drop down list - but effectively free text)
7. Action owner (email hyperlink)
I would like to set up a process whereby these actions can be assigned to the Action Owner as a task in Outlook.
Once a task is assigned the date is populated into a corresponding column so that I know it has been assigned (also assuming the 'button' will want to know which tasks have already been assigned)
Any help would be appreciated!
I have a basic 'action tracker' spreadsheet with the following columns:
1. Action Number (Unique ID)
2. Issue (Free text)
3. Action Required (Free text)
4. Target Date for Completion (Date Field)
5. Category (Drop down list - but effectively free text)
6. Risk Rating (Drop down list - but effectively free text)
7. Action owner (email hyperlink)
I would like to set up a process whereby these actions can be assigned to the Action Owner as a task in Outlook.
Once a task is assigned the date is populated into a corresponding column so that I know it has been assigned (also assuming the 'button' will want to know which tasks have already been assigned)
Any help would be appreciated!
