-
Recomendations on templates for project portfolio with dashboard
Hi, I am new to smartsheets and have been tasked to build a project portfolio (list of projects for each team with status, dates, notes) and then create a dashboard view. Can anyone recommend a template to build this quick and easy? We did have a consultant build a solution for us years ago but it did not work properly; so…
-
Message Error in POWERBI 'https://api.smartsheet.com/2.0/home' (500): Internal Server Error
Hi everyone, I use Smartsheet as database for mis PowerBI reportes. The problem is, when i try load the data with Refresh in PowerBI, appears the following message: 'https://api.smartsheet.com/2.0/home' (500): Internal Server Error I tried with another sources, and works fine, the problem is only with Smartsheet. Any…
-
2025 Free Smartsheet Webinars/Office Hours
I hope everyone is having a great start to their year! I am posting here because I wanted to share the schedule for the Smartsheet Webinars we will be hosting this year. Here’s a breakdown of the schedule for the first half of this year: Office Hours: Starting in February, our Customer Success Manager, Lisette Planken,…
-
Dashboard Templates
I designed a dashboard to capture our department's customer communication. There is a form that populates our communication log, reports and feeder sheets that breakdown each team members' bucket of logged calls, and a bar graph categorizing the types of calls. I'd like to have a clean sheet/reports for our Annual Report…
-
Add Work Insights to Dashboards
I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…
-
Dashboard Sheet name Hyperlink proposal
I have a dashboard with a summary report that shows all my records within my Smartsheet, within the report i have the sheet name column which acts as a hyperlink and takes the user to the associated sheet where the record is located. The problem is the link takes the user to the page but leave the user having to go and…
-
A PowerBI novice's guide to embedding dynamic reports in Smartsheet dashboards
I've recently embarked on a foray into linking PowerBI with Smartsheet, with the goal of creating dashboards where data can be sliced and diced interactively, and which update with new data automatically. The purpose of this post is to share the steps I had to go through, along with a few learnings, so that other novices…
-
Dashboard Assistance
Currently, I have a dashboard that reports on our Current and Completed jobs (two unique sheets). There's two fields I'm looking to add together and return the sum onto the dashboard to display our dynamic Currently Billed to Date number. Datapoint 1 - exists in the Sheet Summary for the Current Projects sheet. This…
-
Dynamic Filter on Dashboards
I really miss allowing the user to actively filter information from their dashboard view. I wish I could have a filter button that could be positioned on the dashboard. Then the user could choose to see the data of a period or a project, for example.
-
New and Ready to Build!
Hello all! My name is Sarai and I work for a municipal government in Texas. I'm new to Smartsheet and love learning new things. Currently, I am building an inspection compliance tracking sheet to oversee about 400 sites. Is it possible to build a dashboard that showcases all aspects of a single site based on an ID number…
