Guide · Updated 2026-10-02
How to Link Evidence to Each Matrix Cell
Every dated requirement should point to its proof — a hyperlink, attachment or software evidence field on that same worker-requirement pair. A shared drive full of PDFs with no matrix link is not an evidence system.
Quick answer
For each requirement cell (or adjacent column), store a direct link or attachment to the file that justifies the date. When the date changes, replace the file in the same step. Spot-check links monthly — broken paths are silent failures.
Spreadsheet options
- Hyperlink column beside each major credential
- Comment with path (fragile — prefer real links)
- Power Query / controlled SharePoint library with matching names
- Avoid embedding huge images inside the workbook itself
Operating rule
- Receive evidence.
- Name the file to standard.
- Update the date.
- Attach or link on the same requirement.
- Only then clear the gap log line.
Software that binds file and date on one record removes the classic failure where Excel says 2028 and the folder still holds the 2023 scan.
Honest limits
FieldClear is built to keep evidence with the requirement row. Linking discipline still matters during Excel use and migrations. Not legal advice.
Already have a spreadsheet?
Upload your existing matrix and see who’s current, what’s expiring and what’s missing.
14-day free trial. No card required.