Automated calendar using Google Sheets (project timeline)


I am looking for a Google Sheets (spreadsheet formulas) expert to create an auto-generated calendar based on a list of data inputs. The goal is to create a calendar project milestones timeline.

The sheet will use two tabs:

tab 1 - the auto-generated calendar

tab 2 - data that will provide the information needed to create the calendar

The data tab 2 would list the source data in the following format:

Milestone name Start Date Duration (in days) End Date Adjustments Days

The Milestone name will automatically populate in the day or days calendar cell(s) that are specified by the Start and End Days. Adjustment Days can be ignored by the GAF freelancer. That allows me to adjust the subsequent days.

The Data tab 2 is already coded the way I need it to work, so you may just use the data to collect data for the calendar coding.

The Calendar

I created a non-working mock-up of what I need in an automated calendar.

What I require for a completed project:

1) The calendar should be automatically generated based on the data available in tab 2

2) The format should look like the mock-up: Mon Tue Wed Thur Fri Sat Sun (Saturday and Sunday are minimized)

3) Each day of the month, should allow up to 2 different milestones (to allow overlap). Again, review the mock-up.

4) Each calendar date is uniquely color-coded to represent a unique milestone. Can this be accomplished using formulas? If not, I can use Conditional formatting.

5) The calendar should be able to handle up to 12 months of milestone events. Tab 2 currently has 22 milestone events for demonstration purposes.

6) The calendar must be entirely self-contained and cannot use any external plug-ins.

7) All calendar calculations must be done using formulas. This means no pivot tables, filters, etc.

Payment will be released upon satisfactory testing of automation and meeting the requirements of this project.

On acceptance of freelancer, I will supply a Google sheet with 3 tabs:

Tab 1 - Automatic Calendar - Blank calendar tab (where the work can be done)

Tab 2 - Data Input (sample data to feed the calendar)

Tab 3 - Mock-up calendar

Deadline of project: ~ 2 - 3 days?

Project time: 1 - 3 hours for a skilled Google Sheets author


- Google Sheets formula expertise

- Excel formulas expertise (Important: The final project must be in Google Sheets)

Successful bidders:

- I will only chat with bidders who have demonstrated that they have read and understood my requirements.

Evner: Excel, Google Sheets, Google Cloud Platform

Se mere: bid project creating site using google sites, good customized websites using google calendar, doctor scheduling using google calendar, project calendar template google, google sheets templates, event schedule template google docs, how to use google sheets for project management, google sheet templates project timeline, google sheets roadmap template, project timeline google sheets, google sheets timeline chart, project using google maps access, using google calendar room bookings, using google cdn project, automated report using google api, google sheets project management template, google sheets project timeline, insert google calendar in google sheets, content calendar template google sheets, social media calendar template google sheets

Om arbejdsgiveren:
( 23 bedømmelser ) Seattle, Canada

Projekt ID: #26878115

Tildelt til:


Greetings, This seems like a neat little project, I might even adapt it for myself later. Using Start Date, Duration and End Date is redundant, which 2 of them would you prefer using? If it *does* happen that a day c Flere

$50 USD in 2 dage
(1 bedømmelse)

20 freelancere byder i gennemsnit $126 på dette job


Hi, Greetings! ✅checked your project details: Automated calendar using Google Sheets (project timeline) ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience i Flere

$220 USD in 4 dage
(361 bedømmelser)

Hi, I have gone through project description and attachment and have few queries which I would like to discuss with you. Keen to work on this project. Recently completed Google Sheets/Google Maps based projects with Flere

$150 USD in 4 dage
(56 bedømmelser)

Hi, Thank you for the meticulously detailed out job description and for the mock-up provided. I have the expertise in google sheets formulas necessary to deliver this Project. Please revert to discuss and finalize at t Flere

$250 USD in 3 dage
(14 bedømmelser)

Hello I am a Google sheets, Google Data Studio, Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros.

$140 USD på 1 dag
(56 bedømmelser)

Hi there. I can create an auto-generated calendar based on a list of data inputs. I am an Excel expert and have been working on process automation projects since 10 years. Please consider me for this job, I am well v Flere

$95 USD in 2 dage
(46 bedømmelser)

Hi! I have it ready as a mock-up.. I am an engIneer and Excel/VBA/Macro expert and Google Scrpit , Google Sheets expert too. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Ap Flere

$80 USD in 3 dage
(13 bedømmelser)

Dear client, I can help you with your project of data entry in excel, VBA, excel macros, VB, ready to start right now, message me and let is discuss about the project and time. Ready to start right away

$89 USD in 7 dage
(11 bedømmelser)

Hello, I can help to complete your project. I have done similar projects in past and will deliver exactly what you need. Please visit my profile to see my work. Please invite me for a chat and let's discuss this furt Flere

$140 USD in 7 dage
(4 bedømmelser)

Hi, Good day. I understand you need a good automated calendar done in Google sheet. A work that provides accurate computations while being easy to understand. I will like to assist you on this project as I have a great Flere

$77 USD in 3 dage
(2 bedømmelser)

Hey mate! I am interested in your project. i am capeable in all our required in all skills which you want. You can trust over me for this project

$44 USD in 3 dage
(0 bedømmelser)

I think I'm better for this job Relevant Skills and Experience I have experience of about 1yr

$30 USD in 3 dage
(0 bedømmelser)

Hi there, I have read requirements to format the file properly and in proper way so that it can be printed out and can do this work accurately and fast. I am expert in Data entry, Excel, Data Processing file conversion Flere

$100 USD på 1 dag
(0 bedømmelser)

Data entry

$156 USD in 3 dage
(0 bedømmelser)

I will complete this in 4 days And if yo want to complete in with in a day I will do it faster I am a biginer Help me

$40 USD in 4 dage
(0 bedømmelser)

Hello. How about today? High-quality & Fast-delivery is promised! As a highly skilled Full-Stack developer and I can help you perfectly. I am very confident with my skills and I'd like to help your business by doing my Flere

$225 USD in 7 dage
(0 bedømmelser)

I am the best candidate that you are looking for. I have great efficiency of working. I guarantee you that your work will be completed will before the deadline. Work will be done as per your demands. Relevant Skills a Flere

$167 USD in 3 dage
(0 bedømmelser)

Hi, i am Mahmood full-time freelancer Digital Marketer, SEO expert, video editor and Excel expert. i would like to take over this project and also want to ask some question about your project Automated calendar using Flere

$250 USD in 2 dage
(0 bedømmelser)

Will perform the work that you want. Make your spreadsheet awesome with my Technical skills that will help you with your business.

$56 USD in 2 dage
(0 bedømmelser)

Hie.. U can consider me for this project.. I have had done similar exercise in past

$156 USD in 3 dage
(0 bedømmelser)