-
How to display names instead of email + names when making a bar chart with a contacts column?
Hi! I'm trying to make a bar chart that shows # of tasks for each person in the project. I used the contacts column, and it shows as just their names in my sheet, as well as in the report I am pulling this from. But when I put it into a chart, it is so cluttered with their emails, and I just want their names only. How do I…
-
Interactive Dashboard without Dynamic View?
Hi, I have a sheet where the user enters a code which then brings back metadata from other sheets. I would like to have this field on a dashboard so the end user doesn't have to navigate to the sheet but enters it in the dashboard (which is the field in the sheet itself). I have searched and I think this is possible with…
-
Rounding to nearest Thursday in the past or current day if it's Thursday
Hello! Long time listener, first time caller — We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the current Thursday, if today is Thursday. In other words, the date should always display a Thursday date; if today == Thursday,…
-
Can't see some sheets Report widget data
I am trying to create a report widget and when I go to the navigation pane for Data source, and I click on my workspace it doesn't load the sheets in the dropdown. I am the owner of the workspace and sheets.
-
Merged: Risk Matrix widget
This discussion has been merged.
-
Improved PDF Exporting of Dashboards
I have created a dashboard that I would like to export to PDF to share to people that do not necessarily have Smartsheet and more importantly don't want to open links/attachments to get "quick glance" data. When I print as PDF I loose a lot of formatting and can't centre the data across the page. without customising…
-
Dashboard on a website
Hi, is there any information or documents that tells me how to make a dashboard visible on a website. I want to have a dynamic (Smartsheet) dashboard on my website. Thanks
-
Bubble Chart / Heat Map
It would be nice to have the following: 1) a poll that collects data based off of criteria for Impact for a given project 2) using a range of 0, 1, 2, 3, 5, 8 13, 21, 32 3) sum up the criteria for the Impact to use as a value in the bubble chart 4) a poll that collects data based off of criteria for Effort for a given…
-
Auto login to Resource Management from Dashboards and WorkApp
While Smartsheet did recently release a method for accessing Resource Management from the left navigation, our team finds more value in looking at the "Reports" I've set up within RM. Reports that I've embedded within our Smartsheet WorkApp, as well as within Smartsheet Dashboards. Issue is, when trying to review the…
-
Sights separator lines
Hi All! Could someone tell me how to add kind of separator line like this one? It is sight from smartsheet's template. It is fully interactive, so if I want make it wider, it is enough to drag the corner of this field. I tried to add a picture of a line from an icon, but it does not expand its width.