Custom Task List & Tracker in Google Sheets/Excel
Budget: $30 – $250 AUD
I'm looking for a custom task list/tracker that works both in Google Sheets and Excel, or a version that can easily be converted between the two. Open to negotiations - if you can provide every function I need, . Faster the project is completed the better, need it ASAP.
Key Functions:
- Automatic Due Date Reminders: The sheet should be able to send reminders when tasks are due.
- Progress Tracking Charts: I need a visual feature to track task progress, ideally via charts.
-Daily/weekly/yearly calendars: daily should be integrated into the weekly calendar, with a “tasks” checklist within. The checklist needs to contain 10-12 columns of headers.
- Data Validation for Input Fields: To prevent errors, it should have data validation on input fields.
-info/data and a Templates feature: allows me to input data into one area of the spread sheet and have that data auto populate into a template (already have). I also need to be able to list all of my templates and have the data auto-populate depending on which one I need.
Bills feature:
Desired Features:
- Templates for Different Tasks: I'm looking for a system that can handle different task types, with customizable templates.
- Billing Functionality: The sheet should have a billing system for invoicing.
- Calendar Integration: It should be able to integrate with a calendar for easy scheduling.
-Within daily/weekly task schedule: I need a feature allows me to track/record “date, time spent, and activity”. Once that info is filled out, I want it to automatically be put into a place on the same sheet that is titled “hours to put in” or something like that.
Ideal Skills and Experience:
- Proficient in both Google Sheets and Excel
- Experience in creating task lists and trackers
- Knowledge of automated reminders and integrating calendar features
- Familiarity with UI/UX design for this kind of project
- Previous work with billing and template systems in these programs.
***Note: Budget fixed
Key Functions:
- Automatic Due Date Reminders: The sheet should be able to send reminders when tasks are due.
- Progress Tracking Charts: I need a visual feature to track task progress, ideally via charts.
-Daily/weekly/yearly calendars: daily should be integrated into the weekly calendar, with a “tasks” checklist within. The checklist needs to contain 10-12 columns of headers.
- Data Validation for Input Fields: To prevent errors, it should have data validation on input fields.
-info/data and a Templates feature: allows me to input data into one area of the spread sheet and have that data auto populate into a template (already have). I also need to be able to list all of my templates and have the data auto-populate depending on which one I need.
Bills feature:
Desired Features:
- Templates for Different Tasks: I'm looking for a system that can handle different task types, with customizable templates.
- Billing Functionality: The sheet should have a billing system for invoicing.
- Calendar Integration: It should be able to integrate with a calendar for easy scheduling.
-Within daily/weekly task schedule: I need a feature allows me to track/record “date, time spent, and activity”. Once that info is filled out, I want it to automatically be put into a place on the same sheet that is titled “hours to put in” or something like that.
Ideal Skills and Experience:
- Proficient in both Google Sheets and Excel
- Experience in creating task lists and trackers
- Knowledge of automated reminders and integrating calendar features
- Familiarity with UI/UX design for this kind of project
- Previous work with billing and template systems in these programs.
***Note: Budget fixed