I manage several projects at the same time in a "Funnel Report". There are several steps for each project to get to completion. All of these steps depend on the Due Date of the project itself. I would like to "link" the dates from my Excell spreadsheet to the calendar - as appointments - to serve as reminders for each task needed for each job. I also have other people working with me so the google calendar I think is good, because email addresses can be added to each appointment to send invitations to other ppl.
I also need to have the flexibility to customize the spreadsheet in any way i need.
I envision that for each task I write for every job, to be able to have a "Link" button that can send the information directly as an appointment in google calendar.
Please see the attached numbers file as an example of how the funnel report looks like. What i need is whenever i set a task date for one of the projects to have an option question " make this a calendar appointment ?", if yes then to ask the hours of the day, invite email... and then to send all info into the google calendar...