-
Stacked Bar Chart using Metrics and multiple data sets
Hello, I am struggling to gather data together from multiple data sets to represent as a stacked bar chart. I have large spreadsheets that use dropdown options for data I need such as customer journey and impact rating (high, medium, low) there is a lot of other data in these sheets as well and they are over the 100,000…
-
2 Reports not showing on my published dashboard
When I publish my dashboard 2 reports are stating they need to be viewed on Smartsheets. the other 3 reports have viewed no problem. They all have the same permissions levels. HTTP s://app.smartsheet.com/b/publish?EQBCT=3c11a22bbcc142df8368f9ac975c1ec4
-
Current user in dashboards
Hi All, I've seen an old message on this topic, but I'm writing to see if there have been developments since (or any work-arounds) to getting "current user" to work in dashboards. I love the new charts, and formulas for presenting summary information. However, for our organisation the real game-changer will be when a…
-
CONTRACT EXPIRATION DATE
1-I am trying to reference another to provide results of contract expiration date - 2- I would like to display in a dashboard the percent of total contracts that has expidered, will expire in 1year, 6month, 90 days 30 days, 14 days and 7 days 3- finally if there was an extension, to input that date in a new column that…
-
Ongoing Performance Evaluation Setup Dashboard - Form Won't Populate
Hi - I was asked to set up this dashboard: The template has been downloaded and the new workspace has been created. The form is set up, and when I did a test fill out of the form, the data went to the "Feedback: Positive" report, (which populated onto the feedback portion of the dashboard) but the data won't populate to…
-
Dashboards - Auto send PDF
Can I send a PDF of a Dashboard on a reoccurring basis? Recipients just want to receive by email on a regular basis and not need to login to view.
-
Is there a way to share a dashboard to multiple stakeholders but can only see information specific t
Is there a way to share a single dashboard to multiple stakeholders but can only see information specific to them based on email?
-
Count Cells that begin with a specific text
I wanted to COUNTIF the number of cells that start with specific four letters in a column of a reference sheet. I used the formula below and it returns zero. =COUNTIF({Reference Sheet}, "ABCD") Is there a formula to return the number of cells that have the first four letters as "ABCD"?
-
Dashboard Chart Errors for Other Users
Hi, I have created a dashboard with bar chart widgets - these charts are showing all relevant data for me, but when my colleagues (under their own smartsheet log-ins) open the dashboard, the charts are showing a 'data range cannot be shown' error. How do I make it so that the data can be seen by others with access to this…