Planned · on the roadmap

Live spreadsheets for Smartsheet

Sheets is coming to Smartsheet: your boards, items and columns as live tables that formulas, pivot tables and charts read directly, without exports.

  • Spreadsheet formulas
  • Pivot tables and charts
  • Scheduled e-mail reports
Planned reports

What you will build on Smartsheet

Each is one formula on live data. These are examples of the syntax: the column names will follow Smartsheet's own fields once the integration ships.

=data.projects.sum(budget, status, "Working on it")
Totals across boards. One sum or count over several boards at once.
=data.projects.sum(actual)-data.projects.sum(budget)
Budget vs actual. Planned and spent amounts side by side.
=data.projects.count(id, owner, A2, status, B1)
Status by owner. Items per person and status, as a pivot.
The data

Tables from Smartsheet

Boards · Items · Subitems · People · Updates

How it will run

Your data stays in Smartsheet

You will sign in with your Smartsheet account and give Sheets read access. Sheets runs on our servers in the EU and reads your data through Smartsheet's API when a sheet opens or refreshes. We plan to list it in the Smartsheet Marketplace.

Want it?

Vote for Sheets for Smartsheet

A thumbs up moves Smartsheet up the roadmap. Leave your e-mail address too and we write once, when it ships.

We use your details only to answer you. Privacy policy

Work management: works today

FAQ

Questions

Is Sheets for Smartsheet available?

Not yet. Smartsheet is on the Sheets roadmap. Give it a thumbs up and leave your e-mail address on this page: we tell you when it is ready, and the votes decide what we build next.

What will Sheets read from Smartsheet?

Your boards, items and columns, as tables: Boards, Items, Subitems, People, and Updates. Each table becomes a data source that formulas, pivot tables and charts read live.

Will Sheets change anything in Smartsheet?

It is planned read-only: Sheets reads your Smartsheet data and does not change it.

What works today?

Sheets works today with QuickBooks Online, Xero, Shopify, WooCommerce, BigCommerce, HubSpot, FreshBooks, monday.com, and Asana.

Want Sheets for Smartsheet?

Requests decide what we build next. We write once, when it is ready.

85 tools on the integrations page