-
Is there a way to embed a sheet/cells into a Dashboard to clearer visual?
I'm trying to create an invoice via a Dashboard and I need to embed a breakdown of the itemized line items from another smartsheet sheet. I usually screenshot the sheet and import it via a widget but the image gets very blurry and not as clear as it is on the original cells/sheet. Is there a way to embed it as a link so tha…
-
Where is the best place to find help with Power Automate Integration
I happen to be the power automate guru for my team, which isn't saying much. Problem I'm trying to solve: when a cell updates (based on certain target columns), extract that info to a SharePoint list (or some other repository). Why? We have several different project tracking systems and want to consolidate info into one…
-
My Half-Donut is not reflecting the correct percentages
I have several half-donut charts that show a goal progression that are reflecting correctly. Two of the charts are not reflecting the correct percentages of completion. What am I doing wrong?
-
Dashboard Graph - Most effective way to cross reference multiple sheets on one graph
Hi all, I have a team that wants one primary graph that will include the following information: Number of peaks / troughs Functional Team Date / Month Basically the graph will extend out to May of 2024 and show the number of peak / troughs by functional team per month. The problem I'm running into is that this team…
-
How to display numbers correct in a stacked column in a dashboard?
Hi all when I am creating dashboards and using the "stacked Column" with a couple of values - the display is always confusing the customer. The number per value is displayed ABOVE the connected layer instead of inside the connected layer - here an example: This is it today with the number always above the appropriate…
-
How to count tasks across all sheets in a workspace
I have a master metrics sheet that I am using. I'd like to be able to count tasks by assigned to across all sheets in a workspace. The goal is to have this formula work if/when any new sheet is added to the workspace. Reports are not really working for me because my assigned to column is a multi-select column. I don't see…
-
How to track time in status?
I have a status column used for the tasks on projects. I'd like to track how long a task (row) stays in a particular status (e.g. in progress). I'm not quite sure how I would get this data.
-
Enhancement request - Series Behavior on Dashboard
Hey everybody, Right now, the series categories on dashboard graphs can only be toggled on and off (like nephrology below). I was wondering if an enhancement could be made so that when someone clicks on a specific category (such as nephrology), it will only show that particular series category and hide everything else.…
-
Question about series behavior in dashboard
Hey everybody, Right now, if I click on an individual series on my dashboard, it will hide it on the graph (like in the nephrology example below). Is it possible to change the series settings so that when someone clicks on an option (such as nephrology), it will only show that particular series and hide everything else? I…
-
Allow Summary from Report Group as a metric option on dashboard
The grouping and summary feature is great and in some circumstances may replace the need to create some sheet summary fields. However, in absence of being able to use as a metric on a dashboard, unfortunately this duplication may still be required.
