Closed

Task Tracking Smart Excel Sheet

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.

Skills: Excel, Excel VBA, Microsoft Access, Microsoft Office, Microsoft Outlook

See more: free excel project management tracking templates, multiple project tracking template excel, excel spreadsheet templates for tracking, excel task tracker template, free project management templates excel 2007, project tracking template excel free download, project management dashboard excel, project plan template excel 2013, DATA ENTRY OFFICE. SALES ANALYSIS, DAILY,WEEKLY,MONTHLY,YEARLY REPORTS, script task copy data excel sheet, sales tracking excel sheet, excel sheet sales tracking, excel sheet weekly sales, project tracking excel sheet, excel sheet tracking work progress

About the Employer:
( 0 reviews ) United Arab Emirates

Project ID: #17018427

24 freelancers are bidding on average $206 for this job

schoudhary1553

Hello, I can help with you in your project Task Tracking Smart Excel Sheet. I have more than 5 years of experience in Excel, Excel VBA, Microsoft Access, Microsoft Office, Microsoft Outlook . We have worked on seve More

$250 USD in 3 days
(241 Reviews)
7.5
fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser More

$211 USD in 3 days
(86 Reviews)
7.3
katilinas

Hello, I'm ready to work on tracking smart excel sheet project. Relevant Skills Excel, VBA Milestones 90 USD - project requirements done and delivered 90 USD - last milestone after full checking and testin More

$250 USD in 10 days
(112 Reviews)
6.5
dpune

A proposal has not yet been provided

$138 USD in 10 days
(117 Reviews)
6.2
renesontiongson

Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$200 USD in 3 days
(67 Reviews)
6.1
aanvikm

Hello Sir, I would like to discuss this project with you. I am an expert with VBA programming. Thanks Aanvik

$277 USD in 3 days
(40 Reviews)
6.0
fatimatuzzohura

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

$277 USD in 3 days
(119 Reviews)
6.1
royalcalif

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the project More

$30 USD in 1 day
(86 Reviews)
5.8
abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat More

$155 USD in 3 days
(46 Reviews)
5.4
$150 USD in 3 days
(7 Reviews)
5.0
$150 USD in 3 days
(35 Reviews)
5.3
$166 USD in 3 days
(34 Reviews)
4.7
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, More

$250 USD in 5 days
(18 Reviews)
4.3
aminw

Hi, Based on your requirement, what you are looking for is actually a ticketing system. A ticketing system tracks assigned data from creation of ticket , assigning task, tracking completion and reporting. You hav More

$750 USD in 10 days
(4 Reviews)
3.7
DataExpert3

I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I have worked on many projects like these, you can check my profile to read my clients reviews ! Pl More

$155 USD in 3 days
(6 Reviews)
2.4
$155 USD in 3 days
(0 Reviews)
0.0
sathish1492

I fully understood your needs...i have done the same thing for my regular docs followup work in my company...and i am sure that i can fulfill the things which u wanted...since it is my first project, pls help me to do More

$111 USD in 2 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
MairaYousaf673

A proposal has not yet been provided

$166 USD in 3 days
(0 Reviews)
0.0
codystites

I would be great for this position for two major reasons. First, I have an accounting degree from the University of Iowa. The Tippie College of Business there offered a great program that effectively prepared me for a More

$155 USD in 3 days
(0 Reviews)
0.0