I need a customized excel sheet where I can assign tasks to other staff with email tagging option, with email response creation for everyone tagged and a CC / BCC column. There should also be Current status column reflecting the status of tasks in percentage and colors. There will be assigned and due dates as well and in case of overdue, an automatic email will be sent to all the parties mentioned in the assignee, CC, BCC columns and myself.
I need a comprehensive dashboard view of the status of tasks on a weekly, monthly and yearly basis.
Column-1: Request# | Column-2: Request | Column-3: Requester | Column-4: Assigned To | Column-5: Action/Progress | Column-6: Start Date | Column-7: Due Date | Column-8: Charts and Dashboards.
During Allocation a task row will be shown green but one day before due date it will change to Blue and after Due date it will turn into RED.
Make this project as efficiently as possible. Simply explained, I need an excel sheet I can assign tasks to people and they receive a notification. also add columns like CC, BCC, so that whatever email id is put in these columns those emails also receive emails and reminders.
Mention columns with start project date and due dates. When a project is assigned color of project row is green, 2 days before the due date send automatic notifications and email reminders to assignee's, CC and BCC columns of that project. Once due date comes change the row colour to red and resend the email reminders and notifications.
Plz add some buttons or templates for Charts and Dashboard where i can create and extract reports of all tasks on weekly, monthly and yearly basis and task status.
24 freelancers are bidding on average $206 for this job
Hi, I am experienced on Microsoft Access , Excel and VBA. I can start your job immediately also. Please contact me to discuss the project in details. Thanks