Manually checking Smartsheet for updated numbers wastes time and creates lag in your OKR tracking. This integration connects your Key Results directly to Smartsheet so metrics update automatically.

When you set up this connection, Rhythms calculates exactly what you need from your sheets (completion counts, weighted scores, time-based metrics, complex filters) without manual data entry. Your OKR progress reflects current data without copying values.

Best used when:

Not ideal for: Objectives (which use automatic rollup instead)

Workspace requirement: Your Rhythms workspace administrator must enable Smartsheet integration. Enable Integrations for Your Workspace explains how admins manage this.

Your access needs: Viewer access to the Smartsheet sheet you want to track.

⚠️ Feature Flag Required
This integration requires the MCP integrations feature flag at the tenant level. Contact your Rhythms representative to enable this capability.

Rhythms will ask you to describe which sheet and what metric you want to track.

Finding your sheet:

Rhythms searches your Smartsheet workspace and shows matching sheets.

Describing what to track:

Smartsheet supports more filtering and calculation options than most integrations. You can track simple counts or complex multi-field logic.

Count or sum based on single field values:

Narrow to specific rows using any column:

Use creation or modification timestamps for velocity and aging:

Combine conditions across unlimited columns:

For progress metrics that need custom logic:

How filtering works: When you describe what to track, Rhythms writes Python code that calculates your metric. This code runs during daily sync.

Be specific about conditions: Instead of "track project status," describe exactly what success looks like: "count projects where Phase equals Development AND Status equals On Track AND Budget Used is less than 80 percent." The more specific you are about what conditions matter for your Key Result, the more accurately Rhythms tracks your progress.

After configuration, check that:

Known constraints:

What syncs automatically:

What you still provide:

Sync frequency: Daily at 3 AM UTC, with manual refresh available via the refresh button

To change which sheet you track or modify filtering logic, disconnect and reconnect.

What's preserved: Progress history remains in Rhythms

What happens: Updates stop until you complete the new connection, creating a gap during reconfiguration

Testing approach: Create a test Key Result to validate new filtering before changing production connections

The disconnect-and-reconnect process is covered in How to Set Up Auto-Updates.

Yes. Each connection tracks one sheet, but you can create unlimited connections. Different Key Results can track different sheets, or track the same sheet with different filters.

Updates stop and Connected to Smartsheet shows an error. Your progress history remains, but no new data syncs until you regain access or disconnect.

No. Each Key Result supports one auto-update connection. For multiple sources, create separate Key Results or manually combine data through check-ins.

Yes. Unlike integrations limited to specific fields like status or priority, Smartsheet filtering works with any column including custom fields, formulas, dates, and text values.

Yes. Every row has creation and modification timestamps. You can calculate time differences, aging, velocity, and time-to-completion metrics by describing what you need.

Yes. Rhythms can execute weighted scoring where different items count differently based on priority, category, or any other field (example: "P0 items count 3x, P1 count 2x").

No. Rhythms reads your sheet data to calculate metrics without making changes to your Smartsheet content.

Verify your filtering logic during setup preview. Create a test Key Result with the same logic to validate. If logic is correct but values differ, data may have changed in Smartsheet since last sync or filtering needs adjustment.

No. Each connection tracks one sheet. Use filtering within that sheet to focus on specific groups, categories, or subsets. If you truly need multiple sheets, consider whether you need multiple Key Results or create a consolidated view in Smartsheet first.