How to Audit a Smartsheet Account

Updated 2026-11-20

Audits of a Smartsheet account tend to be prompted by something specific: an offboarding, a client asking who can see their data, or the discovery of a sheet published to a public URL years ago. The awkward part is that every setting worth checking is held per item, so the answer only exists once somebody opens all of them. Here is the manual route, and how to shorten it.

The four things worth checking, and where they live

Each of these is a per-item setting, read from a different place in the product:

  1. Published links. A sheet, report or dashboard can be published to a URL that needs no Smartsheet login, and some publish settings allow editing. Publishing is set per item, and a sheet access report can list published items.
  2. Sharing. Collaborators are held per sheet and per workspace, with permission levels from Viewer to Owner — so "who can see this client's data" means opening each sheet and each workspace that holds it.
  3. Automation. The workflow manager works one sheet at a time, and a rule Smartsheet has disabled shows as "Unable to run" only to someone looking at that sheet.
  4. Dormant sheets. The sheet list carries a modified date, which is the usual proxy for disuse — a proxy, not proof: a sheet can be read daily and written to never.

Why the manual version rarely gets finished

None of the four has an account-wide view, so the work scales with the number of sheets rather than with the number of problems. On an account of a few hundred sheets, a thorough pass is a day's work that is out of date by the following week — which is why it usually gets done once, after an incident.

The other difficulty is interpretation. A collaborator on a different email domain is not necessarily external; a modification date does not establish that nobody reads a sheet; a published link may be deliberate. An audit that reports these as violations teaches people to ignore it.

Run the four audits in one read-only scan

Our health check runs the published-items, sharing, workflow and stale-sheet audits back to back under one budget, cheapest first, and reports findings rather than data dumps: a count, the worst few examples, and what to do — "3 items anyone on the internet can edit", "7 workflows Smartsheet has disabled". Each finding links into the specialist tool that holds the full list and, where it applies, fixes it.

It reads only — publish settings, sharing lists, automation rules and the sheet list — and fixing anything is a separate, deliberate step elsewhere. Every check shows its own coverage beside its findings, as in "Partial: 250 of 817 checked", because a scan that stopped early must not read as an all-clear; each check examines up to 250 items and paces itself under Smartsheet's API limits. The result is held for one hour so your browser can collect it, then deleted: no collaborator emails, publication links or cell values are stored. Dashboards, multi-step workflows and cell contents are out of scope, and there is a sample report you can read before granting any access.

Official Smartsheet documentation: Publishing items, Sheet access and published items report, Sharing sheets and reports, Workspace sharing, Workflow permissions.

Do it in one pass instead

One read-only scan of your Smartsheet: public links, external collaborators, broken automation workflows and forgotten sheets — with a link to the tool that fixes each. Free, nothing is changed.

Try Health Check Free

Frequently asked questions

How do I audit who has access to my Smartsheet account?

Sharing is held per sheet and per workspace, so natively it means opening each one and reading its collaborator list. A read-only scan can cover the sheets you can access in one pass and report the sharing entries worth a second look, with its own coverage shown beside the findings.

How do I find Smartsheet items published to a public link?

Publishing is set per item, and a sheet access report can list published items. A scan can report how many are published and whether any allow editing, which is the setting that matters most — a published item that can be edited by anyone with the URL.

Does auditing a Smartsheet account change anything?

It should not, and our scan only reads: publish settings, sharing lists, automation rules and the sheet list. Revoking a share, unpublishing an item or pausing a workflow is a separate, deliberate action in the tool the finding links to.