Shared-file permission and input checks
Check file/folder access and record viewing, permitted input and formula protection using accounts with the actual assigned roles.
Access, inherited permissions, protection and actual-role tests correspond.
- File formats
- English XLSX · CSV (UTF-8)
- Version
- 2.0
- Editorial review
- 31 Oct 2026
- Use this for
- Check file/folder access and record viewing, permitted input and formula protection using accounts with the actual assigned roles.
When to use it
Check file/folder access and record viewing, permitted input and formula protection using accounts with the actual assigned roles.
Distributing this log does not change permissions on the actual operating file. Do not enter passwords, sensitive rates or secrets; use approved test-account IDs.
Start with the guide: Shared operations sheets: formula protection and access reviewFill in the template step by step
When to use it
Open a record when preparing the work. Link later checks and changes using the same item ID.
What to have ready
- External/source files, folder locations and approved recipients
- Protected/editable ranges, role test accounts and fictional data
Check internal data/source links and file/folder access.
Test Viewer access and Editor permitted input/protected edits separately.
After fixes, retest the same roles and record sharing and handover.
Worked example
Fictional example, not an actual event or supplier record
Eight columns · scroll horizontally to view the complete worked example.
| File ID, folder and version | External copy and source connections | Direct/inherited access and role | Protected and editable ranges | Test role and environment | View, allowed input and blocked edit | Fix and same-role retest | Sharing decision and follow-up |
|---|---|---|---|---|---|---|---|
| FILE01 / FOLDER01 / v1 | External copy; source links under review | Supplier Editor; inherited access unknown | Formulas C; input B planned | Approved Editor TEST01 | Before test; fictional values ready | Inherited-access check requested | Hold sharing; admin Kim by7 Nov12:00 |
| FILE01-TEST / v2 | Internal data/links removed CHK01 | Direct and inherited ROLE01 checked | C restricted; B exception | TEST01 Editor / ENV01 | Opens; B input works; C still editable BUG01 | Request edit restriction instead of warning | Kim to retest7 Nov15:00 |
| FILE01-R1 / v3 | CHK01; unchanged | ROLE01; approved recipients only | C restricted; B exception retained | Same Editor TEST01; separate Viewer TEST02 | Editor B allowed/C blocked; Viewer access CHK02 | Same-role retest CHK02 | Operations Lee sharing decision and receipt16:00 |
Blank template preview
This preview shows a few rows. The downloaded file contains 24 prepared rows.
Eight columns · scroll horizontally to view the complete blank worksheet.
| File ID, folder and version | External copy and source connections | Direct/inherited access and role | Protected and editable ranges | Test role and environment | View, allowed input and blocked edit | Fix and same-role retest | Sharing decision and follow-up |
|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
Sources used to develop this template
EVENTODIT created this template using the working methods described in the public sources below. It is not an official form and has not been reviewed or approved by those organisations.
- Google Sheets · Protect, hide and edit sheets · Checked 27 October 2026
Adapted to link the guide’s checks with evidence, owners and follow-up records. The fields are editorial proposals, not an authority’s official submission form.
- Google Drive · Sharing roles, inheritance and general access · Checked 27 October 2026
Adapted to link the guide’s checks with evidence, owners and follow-up records. The fields are editorial proposals, not an authority’s official submission form.