-
Aggregating Data (9 sheets for 40 different clients)
Hello, I have 9 identical sheets (obviously data within them differs) for 40 clients that I'd like to aggregate. The clients fall under 3 verticals and those 3 verticals roll up to one division. I have trying to aggregate the data through cross references but somehow have maxed that out (maybe I am approaching wrong?).…
-
Dashboard - Fillable Sheet
Is there a way to put a sheet into the dashboard that can be edited from the Dashboard?
-
DASHBOARD - Shortcut Widget - changed?
I set up a Dashboard many months ago and it allowed me to put Links to WORKSPACES and FOLDERS from the SS Directory. See the Screenshot. I went to update the DB / add another FOLDER, and it would not let me. I had a consultation with a smartsheet basics person on the phone. They said not allowing WORKSPACES and FOLDERS is…
-
Dashboard Creation Using a Form
I have a form that I submit to stakeholders that captures CSAT data. The form specifically captures the CSAT score, the stakeholder product, the internal team that worked on it (e.g., Team A, Team B, and Team C), and the stakeholder's name. The date the form is submitted is also included and auto-populated in another…
-
Merged: Forms as Smartsheet Objects in Dashboards
This discussion has been merged.
-
Is there a way to create a "anybody in the organization can view" view
Here is my situation. I am using Smartsheet as an intake tool for my organization. People from across the business come in and using a form, submit an intake request. One of the data elements I capture is the email address of the submitter I would like to create a report, filtered on the current user, where they can view…
-
Visual / Report for data in a multi-value drop down column
Hello! I have a drop down column with 14 options and the ability to allow multiple values per cell. It is a sheet to show different company internal initiatives, when they are happening, and which team they impact. The impacted team is the multi value drop down. I want to create a visual that shows how many things are…
-
Web Content Widget not automatically showing filter in published sheet
I've set a filter in a sheet, published it and added it to a dashboard as a Web Content Widget. However, the filter I've set is not automatically showing in the dashboard. I don't want users to have to choose the filter. A report won't work for this because I want the dashboard user to be able to do live updates in the…
-
Efficient Monthly Report Data Collection System for Faculty using Smartsheet
I am looking to create a streamlined system in Smartsheet to collect monthly report data from faculty members efficiently. This would include updates on publications, grants submission, presentations, etc. The main goals include consolidating all of this information in one place, providing a user-friendly interface for…
-
Hi everyone, is there a way to create Dynamic view on a dashboard but with charts and metrics?
I am making a supplier-facing dashboard and I would like to make a dashboard that displays personalized data, similar to this video. Instead of a Month dropbox it would display supplier names and the data would ideally display specific or personalized info.