-
Filter for Current User - View on Dashboard not working as planned
Hello Smartsheet people, I have a report that is pulling in all open tickets from a single source sheet, and I want the report displayed on a dashboard. I want this specific report to only show the tickets assigned to the current viewer of the dashboard. The 'has current user' filter is on, and the column type is a contact…
-
Excel Sheets as the base content for Dashboards
Hi- I have team members that are very resistant to anything new. They want to continue to use Excel for their spreadsheets and wonder if the Dashboard and other sheets that folks use in Smartsheets can actively link to their Excel sheets instead of actually having a SmartSheet. I know that Tableau does this - it links to…
-
Dashboard refresh
My sheet gets data from a form and update requests, it rarely needs to be opened directly. I have reports for open items and completed items. I have summary fields in the sheet that count and calculate late items. The Dashboard has metric widgets that look at the summary fields and two report widgets. The dashboard doesn't…
-
Dashboard - Variable Applied to all reports, graphs etc
Hi I have a requirement to report on the current data for a period and using a Dashboard makes a lot of sense except that since I have to analyse the data every week I need to redo the report each time I want to change It would be great if I could create a variable (1 or more) that can be applied to the incoming smartsheet…
-
Create a Map chart?
I'm looking to create a map chart within a dashboard (namely, a chart of the United States, with data in each state visible when hovering over each state). Has anyone done this that can point me to where to get this done? I've seen them in Excel, but have had no luck for this capability in Smartsheet.
-
Watermark a Dashboard?
I think the answer is no, but wondering if it is possible to change the background of a Dashboard/Portal to a watermark image?
-
I'm new, help with dashboard widget, creating a widget to allow someone to submit 2 basic fields
Apologize in advance for my lack of knowledge... Example: I have a smart sheet already created. 2 columns, Company Name & Account Rep. Trying to create a dashboard/portal that will allow anyone to to just submit the Company Name and Account Rep name and have it automatically add to the sheet. Thanks in advance.
-
Is there a way or alternative way in referencing a formula from the Report?
Hi, I have a huge data in my sheet which is automatically fetching data from a google sheet. And to summarize my data to which I need, I am planning to use a Report but when I am computing for a COUNTIF, I have realized that the we can't reference a formula from the Report yet. Is there a new feature to convert Report into…
-
Web Content Widget not embedding Soundcloud
I just want to clarify the following. Are the Embed Enabled Web Content approved domains the only URLs that currently work within the widget? OR Do I need to have the Enterprise Admin allow the domain? Trying to embed Soundcloud channel: https://soundcloud.com/intelcitc OR <iframe width="100%" height="450" scrolling="no"…
-
Webinar recording: Dashboards introduction and best practices
Missed the webinar? Review the recording in the Learning Center. Join us for a two-part webinar series focused on Smartsheet dashboards. Introduction to Dashboards Learn how to build a visual Smartsheet dashboard to provide a robust, real-time view into data from your sheets and reports. Dashboard design best practices…
