Currently I have an annual dashboard created by mostly pulling multiple reports that primarily uses sheet summary data. How can I pull quarterly reports using the dates 10/1/22-1/31/23 to filter my reports? Keeping in mind that I can't filter by columns because I am using sheet summary to build my reports. Here are…
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…
I would love to be able to check off items in a report directly in my dashboards, without being redirected to the source report or sheet. I cannot see how to do this - is it possible? Thanks Hannah
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…
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?
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…
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…
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…
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.
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.…
