A calibration log in SharePoint

Short answer: keep two lists. One list, "Instruments", holds each instrument you track: its name, its serial number and where it lives. A second list, "Calibration entries", holds one row per check: the date, the result as the report states it, a link to the certificate file, and the next due date. A lookup column connects each entry to an instrument. Two saved views then answer two questions: which instruments are due soon, and what is the history of one instrument. This log records what was typed from the certificate or report. It does not tell you what calibration standard applies, how often an instrument must be checked, or what records you must keep. Ask your calibration provider, your auditor or your attorney about that. The exact names of menus and buttons may differ from what is written here, because Microsoft changes its screens from time to time.

Why due dates get missed

A calibration check is a short event. The instrument goes out or a technician comes in. A certificate comes back as a PDF or a paper sheet. The certificate goes into an email or a folder, and the due date sits on a sticker or in someone's memory. Months later a person asks, "When was the scale in room 2 last checked, and when is it due again?" Nobody can answer quickly.

Signs the problem is already there:

Certificates sit in several folders and inboxes.
The next due date is known only by whoever keeps a private sheet.
Two people track the same instrument in two different ways.
Old rows and new rows are mixed, so you cannot tell which check is the latest.

A list does not do the calibration. It gives you one place to put what you received, in the same shape every time.

What you are building

You will build two SharePoint lists:

"Instruments": one row per instrument.
"Calibration entries": one row per check, with the date, result, certificate link, next due date and a link to the instrument.

If you are new to lists, see "Replace a spreadsheet tracker with a SharePoint list". For a similar log built for service work on equipment, see "An equipment maintenance log in SharePoint for a clinic or lab". This guide does not repeat those steps.

Decide what you will and will not record

Plan this before you build. Our advice, not a Microsoft rule:

Copy what the certificate or report says. Do not add fields that only you would guess at.
Ask your calibration provider, your auditor or your attorney which records you must keep, for how long, and what an entry must contain. This guide states no rule.
Keep the log factual. Write the result as the certificate words it. Do not write your own pass or fail judgment into the Result column.
Keep the certificate file in a document library and put a link to it on the row. The list points to the real record.
Decide who can open the list. A view is not security. A view only changes what is shown, and anyone who can open the list can switch to another view. Use permissions to limit access, and ask your admin which groups to use.

Step 1. Create the "Instruments" list

Go to https://www.microsoft365.com and open Lists, or open the lists on your team site. Microsoft's help page on creating a list says: "Choose to start a list from scratch." It also says: "Add a list Name, Description (optional), and select whether you want the list to appear in the left site navigation." Name the list "Instruments". To add columns, Microsoft says: "To add different types of information to the list, select + Add column."

Set up these columns:

Title (Single line of text). A new list has a Title column, and it is required by default. Rename it to "Instrument name" or turn off the Require setting. Type a name people use, such as "Balance, room 2".
Serial number (Single line of text). Copy it from the instrument.
Location (Single line of text). Keep it short.
Calibration provider (Single line of text). The company or lab that does the check.

Add one row for each instrument. Our advice, not a Microsoft rule: add only the instruments you want to track, not every tool in the building.

Step 2. Create the "Calibration entries" list

Create a second blank list named "Calibration entries". Set up these columns:

Title (Single line of text). Rename it to "Entry" or turn off Require. One way to start is to type the instrument and date, such as "Balance, room 2 2026-10-14".
Instrument (Lookup). In the list, add a column and choose Lookup. Pick the list "Instruments" as the source and "Instrument name" as the column to show. Our advice, not a Microsoft rule: make both lists on the same site.
Calibration date (Date and Time, date only). The date the certificate gives.
Result (Choice). Use numbers so your order stays: 1 As found within limits, 2 Adjusted, 3 Out of tolerance, 4 Not stated. Choice values sort by their text, so the number prefix keeps your order. Our advice, not a Microsoft rule: pick the wording your own certificates use, and add a short line next to each choice that says what it means for your team.
Certificate link (Hyperlink). Paste the link to the certificate file in your library.
Certificate number (Single line of text). Copy it exactly as printed.
Notes (Multiple lines of text). Anything the certificate says about conditions or follow-up.
Next calibration date (Date and Time, date only). Copy it from the certificate or from your schedule.
Next calibration logged (Yes/No). Default No. Tick it once the next check for this instrument has its own row.

Why a flag column keeps the "due" view clean

A view that shows "due soon" rows will also show every old row whose date has passed, unless something tells it that the row is finished. Old rows would pile up forever. The Yes/No column "Next calibration logged" is that signal. When the next check is entered, the old row is ticked, and it drops out of the due view. This is our advice, not a Microsoft rule, and it is why the view in Step 4 has two filters.

Step 3. Add an entry

After each check, one person opens "Calibration entries" and selects "New". They pick the instrument, enter the date and the result as written on the certificate, paste the certificate link, copy the certificate number and enter the next calibration date. Then they open the instrument's previous entry and tick "Next calibration logged". One owner for this task keeps the log in the same shape. If the certificate has not arrived, leave the Certificate link blank and say so in Notes, so you can find the entry later.

Step 4. Build the "Due soon" view

This view shows which instruments need a check soon.

Open "Calibration entries". Open the view menu and choose "Edit current view" to open the classic view editor. You can also create a new view and name it "Due soon".
Under "Filters", choose "Show items only when the following is true".
Pick Next calibration date, then "is less than", and type [Today]+30. Connect a second filter with And: Next calibration logged is equal to No.
Sort by Next calibration date, oldest first. Save.

Microsoft's help page on filtering a view says: "There are two keywords that you can use to filter based on the current day [Today], or the current user [Me]." It also says: "It is not possible to use the [Today] or [Me] filters when filtering using a column header." And it says: "You must use the classic view editor to filter columns using these keywords." Its own example uses arithmetic with [Today]: "you can create a filter on the Date column that's greater than or equal to [Today] - 30."

Our advice, not a Microsoft rule: set blank and "is not equal to" filters in the classic view editor too.

Rows with a past next calibration date show here until the next check is logged. If a date has passed and Next calibration logged is still No, either the check happened and was not logged, or it was missed. A person has to look.

Step 5. Build the "By instrument" view

Create a view named "By instrument". Sort by Instrument, then by Calibration date, newest first. For a saved view that you share, our advice, not a Microsoft rule, is to use the classic view editor.

Step 6. Review it once a month

Once a month, one person opens "Due soon" and does three things:

Contact the provider about any instrument with a past or near due date.
Look for entries with no Certificate link, and ask for the file.
Look at Result by instrument. An instrument that keeps showing "3 Out of tolerance" needs a conversation with the provider or the maker. That is a judgment for you, not a rule from this list.

Privacy and who can see the list

The list can hold serial numbers, locations and the names of providers. Collect the least you need. A view is not security. To limit who can open the list, use permissions, and ask your admin which groups fit your site.

What to avoid

Do not store the certificate files in the list. Keep them in a library and link to them.
Do not rely on the list instead of the certificate. Link the certificate.
Do not type a rule, limit or standard into the list as if it were a check. This list only records.
Do not write your own pass or fail judgment into Result. Copy what the certificate says.
Do not treat a view as a lock. A view hides nothing from people who can open the list.
Do not leave the Title column blank. It is required by default. Rename it or turn off Require.
Do not have five people enter rows. Our advice, not a Microsoft rule: one owner keeps rows in the same shape.
Do not delete old entries to clean up. Tick "Next calibration logged" so the history stays.
Do not leave a past due date unexplained.

Honest limits

A SharePoint list records what someone typed. It does not check that a certificate number is correct, and it does not prove that a check was done. The certificate is the record of the check. The list helps you find it.

A list does not remind anyone by itself. The "Due soon" view only shows rows when someone opens it. If you want an email before a due date, that takes a separate Power Automate flow. Also, a person must type every entry. If checks are not logged, the list is wrong.

When to get help

You can build all of this yourself in Microsoft 365. If you would rather have it built and tested for your team, I do that. A tracker like this is a fixed price: $5,000 for one, built in 2 weeks. See "What a SharePoint tracker costs to build". Bring one example of the problem to a free call.

Tell me what's still manual

I am Al Davies. I run 250 High Street LLC and build SharePoint trackers and Power Automate flows for operations teams. I work remotely. The first call is free, and I will not try to sell you anything.

See trackers I built: Tools I built

FAQ

Does this log meet a calibration standard or an audit requirement?

This guide cannot say. Standards and rules differ by place and by business. Ask your auditor, your provider or your attorney which records you must keep and how. This list only records what you type and link.

What should I put in Result?

Copy what the certificate says, in the same words. Do not add detail the certificate does not give. Link the certificate on the row.

How do I show instruments due in the next 30 days?

In the classic view editor, filter Next calibration date to "is less than" [Today]+30, and add a second filter, Next calibration logged is equal to No. Microsoft says the [Today] filter needs the classic view editor. It does not work from a column header.

Can I hide the list from some staff with a view?

No. A view only changes what is shown. To limit who can open the list, use permissions, and ask your admin which groups to use.

Do I need two lists?

One way to start is two lists, so each instrument is typed once and every check points to it. The lookup keeps instrument names the same on every row.