-
is there a way to get "mouse-over" text for a widget on a dashboard?
I have a dashboard with multiple forms linked to it through widgets. To save space, I'd like to be able to have users be able to hover over the form widgets and get a description of what the form is and when to use it. Is this possible?
-
Core App Account Admin Workspaces not showing as options to Provision to in Control Center
I'm hoping someone in the community can assist with a strange issue I'm having: Dashboards for projects that I've previously provisioned and were working are suddenly showing a "Widget needs owner" error. I've fixed the issue by claiming ownership of the provisioned project's widgets, and ensured I am the owner of the…
-
COUNTIFS formula error
I am trying to calculate training sessions based on 2 columns : status column and year column. I've done this numerous times before however for some reason no matter what status filter I choose the outcome is 0 when there are definitely values for 2024 completed training sessions. This is the formula I am using =…
-
Pie Chart using aggregation and words in one of the columns
My question is in two parts: I want a pie chart to display the percentage out of 100 that a certain field is. For example, if I have ten values in a column that are one of: "State", "Federal", "Community" where there are 3 State, 3 Federal and 4 Community. Right now, it won't let me use words at all, so I have to put a…
-
Merged: Trend Line over Column Charts
This discussion has been merged.
-
Can a Viewer interact with a Dashboard?
I use a report to list Open & Closed entries from a sheet. I have a dashboard with the Reporting Widget. Sometimes viewer want to comment on a particular entry they see on the dash. Is there a way to provide a feedback mechanism without granting full viewership to the source file? The source file contains info that I don't…
-
Why automation copies the row 3 times instead of once?
Hi everyone! On Smartsheet, I have a source file for which I created an automation. Through this automation, the 7 rows of the source file (whose values are updated multiple times a day) are copied to another destination file. According to the automation, the copy should only occur once a day at 4:00 p.m., and the goal is…
-
Place Months in chronological order on a Dashboard Trendline Chart Widget?
Context: I am building a trendline report to track number of projects started each month. It has two series, a 2024 and 2025 series. Two keep the months in order, I have put a number in front of the month, e.g. "03. March" so that when I create the trendline the months are not out of order. (e.g. in a previous iteration…
-
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…
-
Consolidate Columns in a Trendline Report
Context: I have created a trendline report that counts the number of projects started each month. I've done so by building out three separate columns that determine the month and year so that I can then plot it on a trendline graph with a 2024/2025 series. The Chart: How the data is organized: Month Formula:…