Click Run the nightly job and watch a scheduled SAS/R job push the night's operational status to the tracker by a stable key — then re-run it to see it converge (never duplicate), and watch the ops-only allowlist block a non-operational column. The grid runs the same deterministic logic as the shipped ss_macros.sas / ss_companion.R.
Representative demo — the same code & logic; no live Smartsheet, no PHI, ops-only.
Smartsheet — CP-101 Program Tracker
>_nightly job — SAS/R → Smartsheet API
On TrackWatchAt RiskPlanned📎 = status PDF attached by the jobgreen left-bar = row appended this run
Operations only. Timelines, status, % complete, milestone dates, ownership — never PHI, participant-level data, unblinded info, or a reported clinical number (a coded allowlist enforces it). Smartsheet is a cloud tracker, not a system of record; validated systems own the authoritative numbers. No AI in the loop — deterministic SAS/R API calls. Full wiki →
⚠ Smartsheet Automation · to: Project Manager, Biostat lead
CP-101 Program Tracker — a task is now At Risk
Row CP101-ENR — Enrollment vs plan changed to At Risk. Sent by the workflow you configured once — triggered by tonight's update.