-
Dashboard overlay
It would be nice to have a graphic in dashboard that you can over lay metrics. Example, a map and then have key points were you can overlay the metrics on each state. This would allow the dashboards to be more visually appealing. I did create a map in Smartsheet but each State is a metric widget. Its not that graphically…
-
Dynamic View and "Group By"
Hi there I have a large sheet that i have used the "group By" function to collate by a particular column fields - when i add a dynamic view to make this sheet editable on a Dashboard it loses the groups and reverts to an ungrouped Sheet view - any thoughts ? Help appreciated :-) Trying to reduce clicks one day at a time…
-
Why would line breaks NOT present in the Report View be present in the Dashboard Widget view?
I have a field I am pulling from Salesforce into Smartsheet that has often has a lot of line breaks in it. I used a CHAR formula to remove the line breaks, and it shows correctly without the line breaks in both the Sheet and the Report. However, as soon as I pull the report into a Dashboard widget, line breaks appear…but…
-
How a dashboard be created from an already active sheet?
Hello. Any feedback is appreciated. I do have a sheet - called "Tasks List" with Task name; Description, tasks health, tasks status, etc. Now, rather than look for a dashboard template and build the list again, can I just create a dashboard out of my already existing "Tasks list"? I've tried but can not find the path or…
-
Freeze columns in a report on a dashboard
If a column is frozen on a report and that report is used in a dashboard, it would be helpful for that freeze to apply when viewing the report on a dashboard.
-
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.