Getting Smartsheet to Take a Snapshot of a Daily Report in Outlook

egold31

Hi Everyone!

Every morning, I receive an automated email in Outlook with a report that includes different tables. I am creating a Smartsheet dashboard and was wondering if Smartsheet has the capability to take a snapshot (a physical image) of that report each morning and have it appear in my dashboard.

Any ideas are appreciated, thank you!

Paul Newcome

Have you looked into just imbedding the report on the dashboard using a report widget?

egold31

@Paul Newcome

How would you go about imbedding the report? To provide some context, the email comes each morning. Within the body of the email, there are 4 tables with the new information for the day (these are not attachments to the email). Is it possible to imbed and Outlook report within Smartsheet? Thanks!

SSFeatures

I agree with @Paul Newcome , you most likely want to embed the report's data directly in the dashboard.

@egold31 you mentioned:

Every morning, I receive an automated email in Outlook with a report that includes different tables.

If the data that you use to generate the automated email is already in SmartSheet as a Report, then you can use the Report widget in your dashboard.

dashboard-report-widget.png

I'm assuming that the automated email was generated by SmartSheet, and the "report" is coming from a SmartSheet Report. However, if by "report" you're talking about an internal report generated at your company using some internal system, and the data isn't already in SmartSheet, then the problem is completely different.

Can you clarify a bit, is the data already in SmartSheet as a report?

Thanks!

SSFeatures

Paul Newcome

@egold31 It sounds to me that when you are saying "report", you do not necessarily mean a Smartsheet Report?