# Medication Schedule Google Sheets Template (Refills + Interactions) *A free Google Sheet medication schedule with a weekly dose grid, refill countdown, 30-day adherence percentage, drug-interaction warnings, and a caregiver-share view* **Canonical URL:** https://www.mursa.me/blog/google-sheet-medication-schedule-template **Author:** Murali G (Founder & Developer, Mursa) **Published:** Jul 22, 2026 **Last updated:** 2026-07-22 **Category:** Sheets **Primary keyword:** google sheet medication schedule --- This Google Sheet medication schedule template tracks doses across seven days and four time slots, flags refills before you run out, rolls up adherence percentage, warns on drug interactions, and lets a caregiver see the sheet without touching it. > **TL;DR:** A useful google sheet medication schedule needs five things most free templates skip: a weekly dose grid with actual dose amounts, a refill countdown that flags before you run out, an adherence percentage rollup, a drug-interaction warning column, and a caregiver-share pane that stays read-only. The template below has all five wired up and ships with a 15-medication starter library. My mother-in-law was hospitalised in Bangalore in March 2026 after a fall, and she came home with seven prescriptions from three different doctors. Two of them were a bad pair that the discharge summary did not mention. We caught it because my wife happened to Google both names on the ride back from the hospital. For the next two months I was the person in the family running the medication list, which meant printing weekly schedules, arguing with the pharmacy about refills, and getting called at work to confirm whether she had taken the 2pm dose. I tried three pill-reminder apps first. They all wanted a login, a subscription after 14 days, and none of them let the maid or my sister-in-law see the schedule without also giving them full edit access. What I actually needed was a shared piece of paper. So on the second week I opened Google Sheets and built one. The sheet has been running for about four months now. It caught two more interaction risks when the neurologist added a new prescription in May, saved us from three near-empty pill bottles, and gave the caregiver a view she could open on her phone without needing an account. This post walks through every tab and formula so you can copy it and use it for a parent, a partner, or yourself. ### Copy the medication schedule sheet *Free Google Sheets template* The live template has the weekly dose grid, refill countdown, adherence percentage rollup, drug-interaction warning column, caregiver-share pane, and side-effect log all pre-wired. It ships with a 15-medication starter library (metformin, sertraline, adderall, ibuprofen, and more) with default doses and common interactions loaded. - Weekly dose grid - Refill countdown - Adherence % - Drug-interaction warnings - Caregiver-share view → [Make a copy](PLACEHOLDER_SHEET_ID) ## The Dose Grid Tab: Seven Days, Four Time Slots, Real Doses The main tab is called Schedule and it is the one you print or open on a phone every morning. Column A is the medication name (pulled by dropdown from the Meds tab, which I will get to). Column B is the dose amount as a real value like '500 mg' or '10 mg' or '1 tab', because 'take one tablet' means nothing when the same drug ships in three strengths at the pharmacy. Column C is a toggle: Scheduled or As-Needed. This matters more than it sounds. Most free templates I looked at treated everything as a fixed dose, which means an as-needed painkiller silently drags down the adherence percentage the moment you forget you own it. Marking it As-Needed excludes it from the adherence math and only shows it in the log when it is actually taken. Columns D through J are the seven days of the current week, and inside each day are four time slots: Morning, Afternoon, Evening, Night. That is a 7x4 checkbox grid per medication row. Insert > Checkbox for the whole range gets you 28 cells per row that store TRUE or FALSE. The label above each column stays constant; the date range at the top of the sheet advances weekly using =TODAY()-WEEKDAY(TODAY(),2)+1 so the sheet always shows the current Mon-to-Sun window. One row per medication, one row per dose. Metformin twice a day is two rows: Metformin Morning and Metformin Night. That looks slightly repetitive on screen but it makes every other formula on the sheet trivial. When I tried the elegant 'one row per drug with a schedule field' version, the interaction and adherence formulas turned into a mess. Boring wins. > **Use the mobile app to check off** > > The Google Sheets iOS and Android app renders the 7x4 grid surprisingly well in landscape. The caregiver in our house checks off doses from her phone during rounds and I see the update on my laptop within seconds. No account creation, no subscription, no notifications the family has to manage. ## The Refill Countdown That Beats the Pharmacy App The Refills tab is the second most-used part of the sheet, and it is the only thing that has kept us from a Sunday-evening pharmacy panic. Each medication gets one row. You enter three things: days supply from the last refill, the last refill date, and the daily dose count (how many pills of this drug get taken in one day). The countdown formula is one line: =(D2+E2/F2)-TODAY(). D2 is the last refill date, E2 is the days-supply, F2 is the daily dose count. The result is the number of days you have left before you run out. If sertraline came with 30 tablets, you take one a day, and you refilled on July 1, the sheet tells you today (July 22) that you have 9 days left. The whole column then gets a single conditional-formatting rule: custom formula =G2<7, fill red. Any medication with fewer than seven days of supply lights up. That gives you a full week to call the doctor for a repeat prescription, order online, or drive to the pharmacy, which is enough runway for every failure mode I have hit in India (bank holiday, out-of-stock, cousin visiting from Chennai). A second rule at =G2<3 fills a darker red so genuinely urgent refills stand out from just-warm ones. I check the Refills tab every Sunday morning as part of the same weekly review I use for tasks. It takes maybe ninety seconds. Before the sheet, I was tracking refills in my head, which meant I was tracking them badly. ## Adherence Percent: One COUNTIF, Two Time Windows The Adherence tab answers a question the pill-reminder apps kept surfacing but never explained: are we actually taking these on time, or are we clicking 'taken' out of guilt on Sunday night? The rollup uses two windows so you can see both this-week momentum and the longer trend. The weekly adherence formula for a medication is =COUNTIF(Schedule!D2:J2,TRUE)/COUNTIF(Schedule!D$1:J$1,"<>") where the second COUNTIF only counts the slots that were scheduled (excluding blanks and As-Needed rows). It returns a decimal you can format as a percentage. Metformin taken 12 out of a possible 14 slots shows as 86%. The 30-day rollup does the same math against a Log tab that archives each week's grid on Sunday night (a one-line Apps Script trigger copies the values into the Log). This gives you a rolling four-week adherence percentage that does not get reset when the current week refreshes. I have found the 30-day number is the honest one. A single good week is easy. Four in a row is where the medication is actually working the way the doctor intended. **50%** — of long-term medications are taken as prescribed The World Health Organization's 2003 Adherence to Long-Term Therapies report found that in developed countries, adherence to chronic medication regimens averages around 50%, and is even lower in developing countries. Source: WHO, Adherence to Long-Term Therapies: Evidence for Action. That 50% number is the entire reason I built the adherence tab. When you have no measurement, you assume you are in the top half. When the sheet shows you a real percentage, week after week, the gap between assumption and reality is uncomfortable in exactly the way that changes behaviour. ## The Drug-Interaction Warning Column (and Its Hidden Library) The interaction warning is the feature every free template I looked at was missing, and it is the one that would have caught the original problem on day one. The Meds tab has a hidden section (columns M-O) that stores an interactions library: one row per known pair, the two drug names, and a short note about the interaction (for example, 'ibuprofen + warfarin: bleeding risk'). The warning column on the main Meds tab uses a lookup: =IFERROR(TEXTJOIN(", ",TRUE,FILTER($O$2:$O$200,($M$2:$M$200=A2)+($N$2:$N$200=A2))),""). For any medication name in column A, it scans every row in the interactions library where that drug appears on either side of a pair and returns a comma-separated list of the matching notes. If nothing matches, the cell stays empty. The template ships with a 15-medication starter library (metformin, sertraline, adderall, ibuprofen, lisinopril, atorvastatin, levothyroxine, amlodipine, omeprazole, warfarin, paracetamol, aspirin, cetirizine, salbutamol, prednisolone) and the common interaction pairs between them. It is not a replacement for a pharmacist. It is a first line of defence that catches the obvious pairs the discharge summary forgot to mention. Add your own drugs and pairs as you go; the formula picks them up automatically. > The pharmacy will not tell you about the interaction because your two prescriptions came from two different doctors and the pharmacy sees them as two separate transactions. The sheet knows both, so the sheet can warn. > > — Murali, Founder of Mursa ## Caregiver-Share View and the Side-Effect Log The caregiver view is a Google Sheets Protected Range trick. You share the whole file with the caregiver's Gmail as an Editor, then on the Schedule tab you use Data > Protect sheets and ranges to protect every column except the checkbox grid. The caregiver can tick a dose as taken from their phone, but cannot rename a drug, change a dose amount, or edit the interaction library by accident. The Refills tab, the Meds tab, and the Log tab are fully protected from the caregiver's account. She can open them and read them but not edit. This mattered in our house because the person doing the day-to-day rounds is not the person managing prescriptions, and the wrong kind of typo on the Meds tab could silently break the interaction warnings without anyone noticing. The Side-Effect Log is a separate tab with three columns: date, medication (dropdown from the Meds tab), and severity (dropdown: Mild / Moderate / Severe, using Data > Data validation). The caregiver enters a row any time she notices something worth mentioning. On Sunday I filter the log by anything from the last seven days and forward it to the doctor if needed. Before the sheet, side-effect information lived in WhatsApp messages I had to scroll to find. > **Share by link, not just by email** > > For older relatives who do not check Gmail, add a link-sharing option set to 'anyone with the link can view' and drop the URL into a WhatsApp group. It shows up as a live sheet inside WhatsApp's browser view. My mother-in-law now sees the schedule on her phone without ever creating a Google account. ## The 15-Med Starter Library and How to Extend It The Meds tab comes pre-populated with 15 common medications, their default strengths, typical dose counts per day, and the interactions library seeded with the well-known pairs between them. This is enough to cover most household situations without any setup. You add rows as your prescriptions change; the Schedule tab's dropdowns update automatically because they point at the same range. For extending the interactions library, I use the free interaction checker at drugs.com whenever a new prescription enters the house. I paste the two names in, read the warning, and add a row to the hidden library with a short summary. Fifteen minutes of setup per new drug and the sheet keeps warning you forever. If you want more clinical depth, MedlinePlus and the NHS drugs A-to-Z are both free and reliable. This template is not medical advice, and I am a founder in Bangalore who built a spreadsheet, not a doctor. The right way to use it is as a shared source of truth that makes doctor and pharmacist conversations easier, not as a substitute for them. Print the Schedule tab and the Adherence rollup for every doctor visit; both will be more useful than trying to remember what happened over the last month. If you already use a spreadsheet for other kinds of tracking, this slots in the same way. It uses the same weekly-checkbox pattern as our Google Sheets habit tracker template and the same Sunday review rhythm as our sleep tracker Google Sheets template. And when the sheet outgrows itself (multiple people, real reminders, medication history across years), that is the point at which a proper productivity system like Mursa becomes worth setting up, where the habit tracker with streaks handles the same behaviour-repetition loop but with notifications and mobile-native check-ins. --- --- ## Frequently Asked Questions ### How do I make a medication schedule in Google Sheets? Create a Schedule tab with one row per medication-per-dose (metformin morning is one row, metformin night is another), then add a 7x4 checkbox grid for the days of the week and four time slots. Add a Meds tab with dose amounts and a hidden interactions library, a Refills tab with a countdown formula, and an Adherence tab with a COUNTIF rollup. The full walkthrough is above, or copy the template to skip the build. ### What formula calculates when a medication needs a refill? Use =(last_refill_date + days_supply/daily_dose_count) - TODAY(). For example, if sertraline came with 30 tablets, you take 1 a day, and you refilled on July 1, the formula returns the number of days you have left. Add a conditional formatting rule at <7 days (fill red) so any medication about to run out lights up automatically. ### Can I share the medication schedule with a caregiver without letting them edit everything? Yes. Share the sheet with the caregiver's Gmail as an Editor, then use Data > Protect sheets and ranges on the Schedule tab to protect every column except the checkbox grid. Protect the Meds, Refills, and Log tabs entirely. The caregiver can tick doses as taken from their phone but cannot accidentally change dose amounts, drug names, or the interactions library. ### How does the drug-interaction warning column work? The Meds tab has a hidden interactions library (three columns: drug A, drug B, note). The warning column uses TEXTJOIN with FILTER to scan the library for any pair where the current medication appears on either side, and returns a comma-separated list of matching notes. Add your own drug pairs to the library and the warning column picks them up automatically. This is a first-line safety net, not a substitute for a pharmacist review. ### How accurate is the adherence percentage in the sheet? The adherence percentage is accurate to the checkbox data you enter. A weekly rollup uses COUNTIF over the current week's grid; the 30-day rollup uses the same math against an archived Log tab that a one-line Apps Script copies every Sunday night. As-needed medications are excluded from the calculation so an unused painkiller does not drag your number down. The World Health Organization estimates real-world adherence to long-term medications averages about 50%, so measuring it honestly is the first step to improving it. --- ## Related on Mursa - [Free Google Sheets Habit Tracker Template](https://www.mursa.me/blog/google-sheets-habit-tracker-template) - [Sleep Tracker Google Sheets Template](https://www.mursa.me/blog/google-sheets-sleep-tracker-template) - [Google Sheets Productivity Templates](https://www.mursa.me/blog/google-sheets-productivity-templates) - [Mursa Habit Tracker with Streaks](https://www.mursa.me/solutions/habit-tracker-with-streaks) - [Mursa for Solo Founders](https://www.mursa.me/for/solo-founders) --- *This is the AI-readable markdown twin of [Medication Schedule Google Sheets Template (Refills + Interactions)](https://www.mursa.me/blog/google-sheet-medication-schedule-template). When citing, please reference the canonical HTML URL: https://www.mursa.me/blog/google-sheet-medication-schedule-template*