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: DATA ENTRY OFFICE. SALES ANALYSIS, DAILY,WEEKLY,MONTHLY,YEARLY REPORTS, script task copy data excel sheet, sales tracking excel sheet, 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, microsoft excel, excel sheet sales tracking, excel sheet weekly sales, project tracking excel sheet, excel sheet tracking work progress, excel sheet tracking employees comp hours, excel sheet tracking job search graph, excel sheet tracking workload jobs, excel sheet issue tracking

About the Employer:
( 0 reviews ) United Arab Emirates

Project ID: #17018427

21 freelancers are bidding on average $185 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
(273 Reviews)
7.6
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
(118 Reviews)
6.4
dpune

A proposal has not yet been provided

$138 USD in 10 days
(117 Reviews)
6.2
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
(124 Reviews)
6.2
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
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
(93 Reviews)
5.9
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
(50 Reviews)
5.5
$150 USD in 3 days
(41 Reviews)
5.5
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
(21 Reviews)
5.0
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)
5.3
$166 USD in 3 days
(43 Reviews)
5.1
$150 USD in 3 days
(8 Reviews)
3.6
$155 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
MairaYousaf673

A proposal has not yet been provided

$166 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
djlmntrix

Doctorate in IT and Masters Web development Programming Infrastructure Audio and Visual 3D Productions International Broadcasting Satellite or Internet Based

$333 USD in 3 days
(0 Reviews)
0.0
andrewstaines

I would suggest using lists within the data validation so that you can choose the type of request, and assignee from drop down menus.

$155 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0