Hi I need the following formula.
We use Google sheets for tracking projects. We need to be able to know when we have assigend a person too many tasks for them to complete in one day. So if we assign them too many hours, something goes red to highlight it.
Here is a sample spreadsheet: [login to view URL]
Column H is the person who the task is assigned to.
From column I to BJ is a ghantt chart
Inside each row for each task, we put in roughly how many hours it will take.
We want to be able to add up the hours that are allocated to each person so we know if we make them do more than 8hrs of tasks a day.
23 freelance font une offre moyenne de $107 pour ce travail
Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Plus
Hello, Hope you are doing well. I can help with you in your project Google Sheets Formula for Tracking Resources allocation. I can assure you the quality job. I have good experience in Excel. We have worked on Plus
Hi there,I am Miljan,Google sheets expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within Plus
Hello? How are you? I have good experiences in "Google Sheets Formula for Tracking Resources allocation" as you can see my profile for these (Excel). I have been working for 7 yrs in this scope. While we contract a Plus
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
Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis Plus
Sir, I am well versed in these kind of jobs and can do your project as per requirement. ***I am ready to start Waiting to hear from you. with thanks and regards Relevant Skills and Experience Google sheet, ex Plus
Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project. I can do figure out the formula to solve the issue you have. Please contact me by chat and then we could discuss better yo Plus
I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department with excellent excel skills and knowledge.
Hello there! I've successfully applied formulas to highlight more than 8hrs of tasks a day for each person. It is also possible to display extra hours if you wish. Anyway, please come to inbox to see what I've done. Plus
Experienced project professional, US based, MBA, EXCEL, SHEETS and MS Project expert; very experienced with Project Resource allocation analysis, Gantt and Histogram visualization of over/under-allocation. I would b Plus
hello! I can help you with your project. I offer you a high quality, accurate and fast turnaround. Why only ask for the formula when I can create the full tracker for you. Please see reviews on my previous projects. th Plus
I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main S Plus
"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional wor Plus
I have 2 years experience in project managerment so this so easy task. Please contact me soon for detail solving. Thanks
Hi. am new here on freelancer. I am really interested in your project because I know am the right man person for this project and am looking forward to a long term relationship
Hello, Thank you for your job posting. I'm an Excel & data processing specialist. I can complete any Excel and Data entry related job with 100% accuracy. I’m a hard working, fast learner, and honest person. I believe Plus
I'm good at excel. I'm interested in taking care of everybody. I like the feeling of being in a team, too. I think I'm perfect for this work.
It can be done by using a pivot table which can be refreshed after new data is available so no need to make it again
Greetings, Very simple [login to view URL] expert is here. I can do this task with high accuracy I am confident that i can deliver best service for you if i am awarded. Please send me a message so that we can discuss more. Plus