Daily Task Spreadsheet Template

₹1500-12500 INR

Posted 1 minute ago

•

Ends in 6 days

₹1500-12500 INR

Paid on delivery

I need a clean, easy-to-update spreadsheet template that lets me organise and track my daily tasks and to-do lists in one place. I prefer working inside a spreadsheet rather than a mobile app, so please build the template for Google Sheets or Excel (either is fine; if you can make it work in both, even better). At a minimum the file should let me: • enter new tasks quickly, • see at a glance which items are pending or completed, • sort or filter by date, status, or any other useful field, and • reset the sheet easily for a new day or week without breaking formulas. Feel free to use conditional formatting, data validation drop-downs, simple progress bars, or other spreadsheet tools if they make the layout clearer and the workflow faster, but keep everything lightweight enough that I can adapt the columns later. A short set of usage notes inside the sheet (or in a separate tab) will be appreciated so I know how to add rows, change colours, or tweak formulas without causing errors. Please send the finished spreadsheet plus any brief documentation when you’re done, and I’ll test it with my real daily tasks to make sure everything is calculating and displaying correctly.

Project ID: 40810235

About the project

3 proposals

Open for bidding

Remote project

Active 4 secs ago

Place your bid

Bid amount Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

3 freelancers are bidding on average ₹4,392 INR for this job

User Avatar
Flag of INDIA

Your daily task spreadsheet — built around the Google Sheets or Excel workflow you described, not a mobile app replacement. Here is exactly what I will build: Capture Layer: data-validation drop-downs for Status, Priority, and Category so entries stay consistent and your filters never break from freehand text. Visual Status Engine: conditional formatting that colour-codes each row the moment you update a cell — Pending, In Progress, and Done will be visually distinct without any manual highlighting. Progress Summary: a header row showing today's completion percentage using COUNTIF against your status column, so you see at a glance how many items are pending or completed. Safe Reset: a guided clear-range method that wipes task data without touching formulas or formatting rules — resetting for a new day or week will not break anything. Usage Guide Tab: plain-English instructions for adding rows, changing colours, and tweaking formulas — written so you can adapt columns later without causing errors, exactly as you asked. One thing worth flagging: if you share this sheet with anyone else, shared editing can overwrite drop-down validation silently. I will lock the validation columns with sheet protection to prevent that. Delivery in 1 day at 5900 INR. One question: do you want the reset to archive completed tasks to a log tab first, or is a clean wipe each day enough?

User Avatar
Flag of INDIA

Resetting a task sheet for a new week usually breaks the formulas that count pending and done items, so the reset has to be built in from the start. I would keep the entries on one tab with a status drop-down and put the counts on a second tab, so clearing the entries never touches them. I have built a payment reminder spreadsheet with a status column and a due and overdue dashboard. I would test the file with thirty sample tasks and a full reset before it reaches you, and the usage notes will sit on their own tab. I would build it in Excel and check the formulas in Google Sheets before the file goes out. Work starts when you award, and the file reaches you within two days of that.

User Avatar
Flag of KOREA, REPUBLIC OF

Hello, I read your post: you want a lightweight daily task template in Google Sheets or Excel where you can add tasks quickly, see pending and completed items at a glance, sort or filter by date, status or other fields, and reset for a new day or week without breaking formulas. I will build it with a Status drop-down, conditional formatting that colours pending and completed rows, a small progress bar for percent complete, filters by date and status, and a Reset button (Apps Script in Sheets, VBA in Excel) that clears task rows but keeps headers and formulas. A Notes tab will explain how to add rows and change colours or columns safely. We make Excel and Google Sheets templates with formulas and data validation, so this is familiar work. I will send a layout preview first, then the finished file; one round of corrections is included. Turnaround is about 2 days. We work from Korea (UTC+9), so files sent in your evening are usually back by your next morning. Price: USD 20 (≈ INR 1875) for the template and usage notes in one platform. I am new on Freelancer, so my price is set low to start our work together. Which do you prefer, Google Sheets or Excel? Any columns you want besides date, task, priority and status? Regards, Sinho

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

把喜欢的内容,留在你的新标签页。

打开我的订阅