-
How to display just 1 specific cell of data in a dashboard?
Hi - I am looking to do some very simple dashboarding where I may display the following in separate areas of a dashboard; Total Number of X Total Number of Y Total Number of Z I want the ability to just display 1 cell of data per widget, that refers to a specific cell in a sheet, but instead I seem to be pulling in the…
-
Disabling sheets, reports and/or dashboards without deleting them
As a company, we are trying to determine what grids, reports, dashboards, etc. that people are using. Is there a way to disable items without deleting them? That way if it is decided that we still need something, we don't have to recreate it.
-
Combining data from sheet in a dashboard chart
Hi everyone, I have a form that I use internally to generate analytics. I am manually adding a certain "amount" per day. I want to visualize how much "amount" I have accumulated per month. The form has a "date" and "value" property which get added to a sheet as "Date" and "Amount". I created a helper column to calculate…
-
Dashboard Templates that can be populated with data from rows
I create individual dashboards each quarter for 15-20 projects then I have to manually link all fields. Is there a way to create a dashboard template that can be linked to the projects that will populate the fields, creating the dashboards? Like a mail merge. The closest I could find to what I'm looking to do is with…
-
Alignment options for Metric Widgets
Hi everyone, wonder if someone has come across this and solve for it. I have a dashboard template as part of a project toolkit (with templates for a project plan, RAID logs, etc). The dashboard itself has a title at the top with the project name. When a PM creates an instance of the toolkit from the template set, one of…
-
URL instead of Display Text for SCC Project Dashboard?
When a project is provisioned in SCC it generates a dashboard link using whatever naming convention is setup in SCC. It doesnt appear to have any options in SCC to make it appear as a url instead? I also am checking the column properties or formulas for a way to make this a URL? The problem is that once a Dashboard Link is…
-
Map for Location Data
Hi, Is there any map feature that Smartsheet provides (or third party) to show on a map data of a location-column on a Smartsheet? Thank you!
-
Count instances in a sheet and plot them against year entered
Hello! Each row in my sheet is a research case. I would like to count each row and plot that number against the year that the case was created. I have a column with the year. How could I do this? I have attached an example of my spreadsheet. In this example I would want a bar graph that says 3 cases for 2020, 6 cases for…
-
Line chart with multiple date-numbers traces
Hello everyone! I can't find a way to accomplish certain kind of chart using chart widget in dashboard. Chart is supposed to show multiple lines, one for each team member connecting dates when a certain task was completed. Tasks are represented by increasing numbers 1,2,3,etc. and can be completed on different dates. I…
-
Date column formula to start on a specific date and continue on after that.
Hello, So I have a helper sheet that tracks total number of entries for each month in each year. Right now I have a formula set up that checks the date above, and depending on if the current month is past that month, it will automatically fill in a new line with the current month (Due to date formatting, I have it set that…
