-
Adding the template "Team Vacation Planner" to dashboard
Hi, The title says it all. I've started using the SS template called "Team Vacation Planner" and I was wondering how I could add this onto a Dashboard for quick viewing. I tried making it into a report but it only brought the columns; sheet name, created, created by, modified by and modified over. None of the names or…
-
COUNTIF + CONTAINS - how do I incorporate them both?
I'm trying to count how many times a value is used in a column. Sometimes the values are alone, sometimes there are multiple in a cell. I got my COUNTIF formula down: =COUNTIF({Christoph Comms Tracker Audience Category}, "Select SMG Employees") But I want to change it so it counts cells that include the value (along with…
-
Color Assignments in Circle Graphs
Hi, I need to add some pie charts/circle graphs to a dashboard. I want the order of the items in the legend to be High Risk, Medium Risk, Low Risk and No Risk. I want the colors Red, Orange, Yellow and Green. I setup the charts and all is well, but it changes the legend to alphabetical and it keeps reassigning the colors…
-
Web content widget - embed iframe
Hello, Is there any possibility to embed iframe that is not from list of approved domains? I'd like to embed Tibco Spotfire report, but its blocked
-
Published sheets on dashboard can't be viewed by anyone shared to workspace?
Hello, I am trying to publish a sheet so anyone who views the dashboard can see and use the sheet. I am finding out that only people who have paid seats can view and interact with the published sheet. This is contradictory to my goal of having ANYONE who is shared to the workspace, even if they don't have a seat, view and…
-
Filtered Dashboards? Setting up a dashboard for a specific location
Hey guys, We are going to be using Smartsheet to track initiatives of our stores. Each of our 120 stores will have 6-20 initiatives inputted into a single form, each as its own row. This form has about 30 columns of various data points, including the store number, and the store manager (contact list). The managers will log…
-
Chart Widget
Hello, I'm creating a dashboard of a program status. I'll like to display a bar chart where I can see in the column the name of the Project and inside the number of activities per status. Like a cumulative columns whit all the status per project Vertical axes: #Task Horizontal Task : Projects Data display in a bar : # task…
-
Is there a way to open the a gantt chart to today in a dashboard view?
The dashboard widget is pulling from a report, which I have updated the project settings to open on today's date. But the view within the dashboard isn't opening on today's date. Any way to update this?
-
Is it possible to rotate a text widget on a dashboard?
Is it possible to rotate a text widget on a dashboard so that it can look like this? I don't see any obvious ways but I'm wondering if anyone has any tricks up their sleeves.
-
What kind of template can I use for tracking new hires as they learn different jobs?
I am looking for a template that allows employees in training and conducting training to report their progress, a notification system that alerts me to concerns raised, and an end dashboard I can use to easily summarize progress and complete further planning. Another goal is to create a sort of plan for each trainee in…
