-
Scatter Plot of Age
I have a smartsheet with many (hundreds) of events. On my dashboard, I would like to display a scatter plot of the age (days) of events as of today. I would like to filter the values, so that only events that are currently open display on the dashboard. I already have a column in my smartsheet with the age of each event…
-
Merged: Ability to set font size in report
This discussion has been merged.
-
Use report count value in dashboards
Hello, I am new to Smartsheets. I have tried searching in the forums, but couldn't get a resolution. Below is the scenario. In Folder - Project Type 1 Project 1 Project 2 Project 3 Using Summarise function of a report, I can get the count of number of projects in each folder. Can I use this count value in a Grid or…
-
Do I need to give permission for everyone so they can view widgets in my dashboard?
I have a dashboard that I want to disseminate out to some volunteers. I just recieved an email from a volunteer that said that he could not see the widgets in the dashboard even though he has access to the dashboard itself. Do i need to go into the reports that are in the widgets and share each one individually with him or…
-
Weekly Reports - Best Practices or Tips?
We need to send weekly reports in one email that pull information from a few different reports. We have it all on one dashboard, but I don't know of a way to send dashboard summaries by email. And they don't want to go to Smartsheet to view it there - it's got to be in an email. Ideally, they want the information in the…
-
Calendar App in Dashboard - remove list of calendars
I am embedding a calendar app into a dashboard using the web content widget. Even though I am using the direct link to the calendar, sometimes the full list of calendars I am shared to appears in the dashboard vs. only the calendar that should be displaying. Is there a way to embed the calendar so this doesn't happen? I…
-
I'm so happy with this landowner contact log system I designed in Smartsheet
Managing landowner communication used to be one of the most time-consuming and fragmented processes at our company. We relied on Word documents buried in server folders. Logging and reviewing landowner details was slow, only one person could edit at a time, and getting a full picture of a project meant manually opening…
-
Dashboard metric widget: Sourced from report metric
The goal I'm working towards is a simple reporting dashboard that summarizes a lot of data. The source data I'm working with a pretty full of extra stuff, so I use the power of reports to quickly parse the data I need, then summarize it to a top-line summed value. I'd like to be able to post JUST that summarised data as a…
-
Edit reports on a dashboard
Request We need an option for the report widget that would allow users to edit report rows while viewing them in the dashboard. The problem I'm trying to solve: I have a report widget on a dashboard that shows users their assigned tasks. I'm using the widget on a Dashboard to give the users one place where they can see and…