-
Send Dashboard via email - manually and automated workflow
My idea is to create functionality to be able to send a dashboard snapshot via email from within Smartsheet, both manually and via an automated workflow. Ideally using an HTML format so any links in the dashboard are links in the email. Smartsheet Dashboards are fantastic and we use them heavily with our project teams and…
-
Mouse-over / Alt-text to Dashboard Widgets
We'd love a way to add "mouse over" alt-text to dashboard widgets to accommodate individuals with color vision deficiency or provide additional context.
-
Veränderte Darstellung eines Berichts nach Platzierung auf Dashboard
Ich habe einen Bericht erstellt, den ich nun über ein Dashboard wiedergeben möchte. Leider wird der Bericht auf dem Dashboard jedoch anders wiedergegeben. Wie kann ich die Inhalte eines Berichts 1:1 auf dem Dashboard darstellen? 1: Bericht -> Kontaktspalte wird wie im Ausgangsblatt wiedergegeben 2: Dashboard -> zeigt…
-
Missing Data on Metric Widget During a Dashboard Global Update
Hello, I recently ran a global update on a dashboard in a child blueprint and found all existing projects now show a "missing data" in a metric widget. New provisioned projects do not have this issue. The metric is pulled from a sheet cell that is part of the project blueprint. The source sheet has not been renamed or…
-
Need formula & function for the question below
If I apply for PTO, I want to make sure it's getting subtracted from the "WR Balance Before Application" and it would be straight subtraction selecting cells & it's sorted. The main formula I am looking for is, If I apply again, my "WR Balance Before Application" should be the latest "WR Balance Left After Application"…
-
Calculation from Sheet with shuttled Data to combined data
I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various…
-
Integrating custom HTML or JavaScript into the smartsheet dashboard.
I wanted to embed a file/URL of a custom HTML code made in order to have a dropdown menu in the dashboard and make it easier to organize data. I think it would be a great idea to be able to integrate custom HTML and JavaScript into the dashboard! Another idea is adding a feature to create a dropdown menu for convenience…
-
Ranking by score
Hello, I have a sheet that contains people and scores (1-100) based on their performance. I want to create a table to show the top 10 and the bottom 10 people based on their score. Any ideas on how to do that? Regards,
-
Any ideas with an issue displaying web content on dashboards?
I've been experiencing an issue since yesterday with displaying a web content widget that pulls content from Excel. I get a Microsoft login page in place of the widget and when I click Sign In, it says I am already logged in. I can access the file outside of the dashboard fine in Sharepoint. Any ideas would be greatly…
-
Need to look for $99,000-$249,000 in Metrics Sheet. Can't find formula error
Need to look for $99,000-$249,000 in Metrics Sheet. Can't find formula error. =COUNTIFS({1. Case Queue Range 6},>"$99,000",<="$249,000")