-
Can you publish Smartsheet Dashboard without sharing underlying Google Sheet data source?
I want to publicly publish a Smartsheet Dashboard as view only and import the data from a live Google Sheet so that it updates in real time. Before I do so, I want to confirm that if I publish this dashboard as view only that the public won't have access to the Google Sheet data source. They should only be able to view the…
-
Sheet Summary Formula versus Sheet/Report Filtering
Hi all, I've been scratching my head on this for a while and I can't resolve why the filtering I do on a sheet/report is not matching my formula on a sheet (upon which the report is based on). Here it goes: I have an intake sheet for my projects that when a PM creates a project via Control Centre, it spits out the expected…
-
How to playback gif in Smartsheet Dashboard? What is the image size requirement?
Hi, Everytime I insert gif image in the dashboard or portal, it is not moving or playback and sometimes I can't insert because of the image size requirement. May I know how you do it correctly? I am using canva on creating gifs.
-
How can I create a quarterly dashboard?
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…
-
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…
