How to display results from original smartsheet in another smartsheet to create a dashboard
Hello!
I am creating an executive summary dashboard for people external to our company. I have a data source smartsheet (primary) that has a lot more detail that I do not want to give them access to.
I would like to create a smartsheet that references specific information from the primary smartsheet, but shows the details, not just counts. I figured out how to do counts using the COUNTIF function, but I want it to display the actual text.
As a use case example:
Primary sheet:
Column 1 - Name of customers
Column 2 - Onboarding Status (In progress, complete, escalated, etc)
Secondary Sheet:
I would like the first column to display the names of anyone in the primary sheet that has an onboarding status of "escalated". I don't want a count, I want their actual names to display.
Thank you for any help you can provide by way of a formula!
AP
Answers
-
Hi @Amy Powell
A report wouldn't do it, displaying rows and specific columns of names and status, with a trigger of "escalated"?
Reporting is specificly designed for such kind of things, so that seems the easiest way.
Do you want to display any other information that you wouldn't be able to do from a report?
-
@David Joyeuse Can I build the dashboard off of the report? Apologies if this is a seemingly sophomoric question, I am new to all smartsheets has to offer!
-
Yes, you can display reports on the Dashboard. It's part of the Widget options. Just select widgets, then pick your report and it'll be displayed on the dashboard.
And there's no stupid questions, we all started one day :P
Hope it helped!
-
I would suggest a Web Content widget with the published report for the dashboard. A regular report widget may or may not show data depending on who is viewing the dashboard.
-
@David Joyeuse @Paul Newcome Thank you so much for your advice, I appreciate your expertise.
I used the report option and it worked great!
I am going to use the web content for another dashboard though, so all of this great insight won't go to waste. :-)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!