-
Data cannot be charted, unable to read source data.
I am using a template from Smartsheet (Project Tracking and Rollup). When I attempt to link the sheet to my chart widget, I get the "unable to display chart" notice. The chart should show percentage complete, but it doesn't. I will add photos of what it should look like, the notice, and the sheet that the chart is pulling…
-
Hide comments and attachments on calendar embedded on dashboard
I am creating a customized dashboard for all of our stakeholders to view events and trade shows within their region. The main file is used by my team to plan all of these events and trade shows, so it has a lot of comments and attachments that I do not want to share with stakeholders. When I created a report to show the…
-
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…
