Smarter Reports to a Sheet

Smarter Reports to a Sheet

Have you ever looked at a Smartsheet Report and thought “I wish I could run a VLOOKUP against this data”?

Well, with Smarter Report to a Sheet, now you can…

What our Smarter Report to a Sheet can do for you

  • Copies the data from a Smartsheet Report and pastes it into a Sheet
  • Does it automatically on a schedule
    that you can define

What our Smarter Report to a Sheet can do for you

  • Leverage the data-collection power of Reports to pull data from sheets across multiple workspaces into one place AND run further data analysis on it

What our Smarter Report to a Sheet can do for you

  • Achieve complex, real-time lookup functions on large amounts of data without the need to create and maintain complicated, time-consuming metrics sheets

USE CASE

Your Accounts department maintains a list of current Projects and needs to know the Percent Complete status for each project.

These values are stored in the individual Project sheets.

USE CASE

You can now use a standard Smartsheet report to gather all these metrics into one place, and copy this data into another sheet.

A simple VLOOKUP from the Project List will then be able to pull all the required data over without creating and maintaining individual cell links.

USE CASE

To get this valuable data into the Project List would previously have meant:

  • Creating a cell link to each Project Sheet
  • Having to create a new cell link every time a new project is launched.