-
Android/Apple Smartsheet app to include form widget
I have a form I'd like to be able to have one-touch access to on my Android mobile. I can do it as a web page in google Chrome, but I'd like to be able to complete the form in the Smartsheet environment on my mobile. Could it be provided as a widget that can be saved onto the homescreen? It would be particularly useful…
-
Embedding iFrame onto Dashboard from Airnow.gov
I maintain several facilities scattered across the state. I am attempting to install the Airnow.gov widget, which will display air quality, onto a dashboard. I get the error "We couldn't find any embeddable content…" I have attempted using the link to the widget itself:…
-
Trying to create Chart widget based on report - but report not showing up as data source option
Hi there! I'm working on a dashboard on which I want to add a chart that displays a bar graph representing the data in a report (report is titled "Tasks in Next 8 Working Days, by Staff"). When I select the widget to create the report, I can select other reports in the workspace, but not this one. I'm baffled because I…
-
Display different report based on day of week in dashboard widget
Hello all, New user here. I am building an updated dashboard for my job and I was wondering if there is a workflow that will allow a report widget to display a different report depending on the day of the week? I have used other examples here in the community to add a widget that displays the days date and day of the week……
-
Dashboard count only if rows filled from a reference sheet
Hi. I am working on a dashboad to summarize some data from a reference sheet. I want to add a metrics widget that presents a sum of the number of rows on a reference sheet only if they are filled with a color completely. Details: I have a sheet with different project rows filled in green, indented under those are 'tasks'…
-
Is there a way around the row limitation on report widgets within a dashboard?
Hello, I have a dashboard which shows a summary of key information from a sheet that outlines purchasing history of our company. It pulls from a report that summarizes information from the main sheet as a widget on the dashboard, and allows viewers to scroll down through the history of purchases line-by-line should they…
-
Sharing a Sheet with a Filtered View
I have created a dashboard with multiple KPIs that are sourced from a sheet that contains all of the raw data. I want to have the user be able to click the KPI widget and view the data that falls under that specific criteria. I have multiple filters set up on the sheet with the raw data, and have linked each KPI widget…
-
Stacked Bar Chart Labels Unable to Show Negative Values
I reached out to Smartsheet support regarding a labeling issue I encountered. When displaying data in a stacked bar chart (example on right), data labels do not appear for negative values. I can only get the negative values to appear on a regular bar chart (example on left). Per the support team, any combination of columns…
-
Dashboard and Widget Action
When creating a dashboard, I have been creating charts and linking to reports using the widget action “open another site” and using the report link. The reason is my team prefers to have the report open in a new tab. Currently, I’m going into each report and adding view access for each user. I have several reports in each…
-
Simple widgets, like a date stamp, for dashboards
I would love to see Smartsheet develop a set of handy, easy-to-customize-the-format widget options for us to use on our dashboards. For instance, it would be great to be able to add a current date/time stamp. Other ideas include a countdown, scrolling ticker, timer, weather/temp, visitor count, etc.
